How to optimize stored procedures in sql server?

0 Answers  

---

What are the components of sql server service broker?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

What are the types of indexes?

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

What is merge statement?

0 Answers  

---

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

2 Answers   Wipro,

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---

What is update_statistics command?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---