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., }


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,


Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,


What is dimension table? : sql server analysis services, ssas

0 Answers  


i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  


How do you know if sql server is running on your local system?

0 Answers  


What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,


What are the steps you must follow to hide sql server instances?

0 Answers  


What is Trigger?

3 Answers   Misys,


Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,


Does group by sort data?

0 Answers  


What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,


Categories