How will you find out if there are expensive SQL statements running or not?


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

Post New Answer

More SQL Server Interview Questions

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  


Why functions are used in sql server?

0 Answers  


Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  


What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  






When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  


What is transaction server explicit transaction?

0 Answers  


How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,


Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,


How does clustered and non clustered index work?

0 Answers  


What is a schema in ms sql server 2005?

0 Answers  


What are the different ways you can create databases in sql server?

0 Answers  


Categories