Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

Explain the properties of the relational tables?

0 Answers  

---

What is dirty read?

0 Answers  

---

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

---

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

---

---

Explain some DBCC commands?

6 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

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 delete an existing database user?

0 Answers  

---