Why would you call update statistics?

0 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

---

How to receive returning result from a query?

0 Answers  

---

Questions regarding Raiseerror?

1 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---