Answer Posted / john t

If you knowfor sure that the number of rows is 10 then the
above answers given above a great examples. So what if you
don't know the total number of rows in that table? Can you
use Select count(*) from nameoftable;

Explain the difference between function and stored procedure?

937

---

Define normalisation?

1105

---

How you can get the list of largest tables in a database?

1007

---

What are the mathematical functions supported by sql server 2005?

1063

---

Explain the dirty pages?

998

---

What is the use of sql profiler in sql server 2012?

886

---

What is clustered index

1001

---

When you use @@error and try-catch?

1039

---

How to rename databases in ms sql server?

1193

---

What is buffer cash in sql server?

1150

---

What is create statement?

940

---

If the job running very slow what is the action you do

1887

---

What is the latest version of microsoft sql server?

1041

---

How to enter date and time literals in ms sql server?

1012

---

define and explain the differences between clustered and non-clustered indexes.

1193

---