Answer Posted / saomya jha

Anything development related should be done in Query
Analyser. Many Management related tasks are better handled
in Enterprise Manager.

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

952

---

Why people hate cursor?

1096

---

Explain about Views?

1007

---

Will sql server 2005 allow you to reduce the size of a column?

916

---

What is the new security features added in sql server 2014? : sql server security

943

---

What is create statement?

887

---

What is surrogate key? : sql server analysis services, ssas

1053

---

What is similarity and difference between truncate and delete in sql?

1028

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1013

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

985

---

How to test values returned by a subquery with the in operator?

1133

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

899

---

Write a query for primary key constraint with identity key word?

972

---

How do I view a stored procedure in sql server?

944

---

What is the process of indexing?

941

---