How can we check the sql server version?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What are the aggregate and scalar functions?

0 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

The Difference between 'Count' and 'Count(*)'

13 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

Do you know clustered and non-clustered index?

0 Answers  

---

Explain what is cte (common table expression)?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

---