How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

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,

---

How to enter comments in transact-sql statements?

0 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

1 01 101 01010

0 Answers  

---

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

What is change tracking in sql server?

0 Answers  

---

What are the joins in sql server? : sql server database administration

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---

What is pessimistic concurrency?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How to handle error or exception in sql?

0 Answers  

---