What structure can you implement for the database to speed up table reads?

0 Answers  

---

Tell me what are the essential components of sql server service broker?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

How do you create type- insensitive operator?

0 Answers   EXL,

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

Different types of keys in SQL?

0 Answers   Infosys,

---

How to test subquery results with the exists operator?

0 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---