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,

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

What are ddl triggers and types of ddl trigger?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

How do I view a script in sql server?

0 Answers  

---

What are the different sql server versions?

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---