What is the purpose of the tempdb database?

0 Answers  

---

Can group by and orderby be used together?

0 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

Why do we use trigger?

0 Answers  

---

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---