Answer Posted / gautam k panjikar

getdate()

What is sql server schema compare? How we can compare two database schemas?

988

---

What are the common performance issues in sql server?

885

---

What is a trigger what are the advantages of trigger?

943

---

What happens if we shrink log file in sql server?

933

---

What is field in algebra?

1002

---

What are a database and a data warehouse?

990

---

Which are the new data types introduced in sql server 2008?

852

---

What are the hotfixes and patches in sql server?

995

---

What is the difference between clustered index and primary key?

884

---

What are the advantages of user-defined functions over stored procedures in sql server?

987

---

How do we know if any query is retrieving a large amount of data or very little data?

937

---

What are the different types of replication you can set up in sql server?

1001

---

How do I create a stored procedure in dbml?

954

---

Does partitioning improve performance?

931

---

How to implement service broker?

948

---