how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Explain what are sparse columns?

0 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

Explain about thread and memory management process of SQL?

0 Answers  

---

---

What are the advantages of policy management?

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

What is the use of floor function in sql server?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

What stored by the tempdb ? : sql server database administration

0 Answers  

---

How to create an identity column?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---