How to start and end transact-sql statements?

0 Answers  

---

What is nested transaction?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

---

Explain different types of locks in sql server.

0 Answers  

---

What is merge replication?

0 Answers  

---

What is difference between rownum and row_number?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

How to create a new table in a given schema?

0 Answers  

---