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

How many ways to create table-valued functions?

0 Answers  


there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  


my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  


How to select some specific columns from a table in a query in ms sql server?

0 Answers  


What is an execution plan?

0 Answers  


Which is best Subquery (or) joins in sql server? explain why

2 Answers  


what is diffrent between store procedure and trigger

2 Answers  


Define DML and DCL statements?

1 Answers   Hexaware, NIIT,


how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,


When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  


What do you mean by sql server agent?

0 Answers  


What is nolock?

0 Answers  


Categories