Answer Posted / g.ashok

Non clustered index is fast

Which sql server table is used to hold the stored procedure script?

948

---

What is difference between getdate and sysdatetime in sql server 2008?

1048

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2108

---

What is the latest version of microsoft sql server?

1047

---

Why use “pivot” in sql server?

1119

---

How to find the version of sql server? : sql server database administration

1111

---

What is the command used to check locks in microsoft sql server?

1044

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1125

---

What is the standby server?

957

---

Which table keeps information about stored procedures?

939

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1034

---

What is normalization and denormalization in sql server?

1017

---

What are the mathematical functions supported by sql server 2005?

1071

---

Find first and last day of current month in sql server

1028

---

how to avoid cursors? : Sql server database administration

971

---