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

Explain indexes disadvantages?

0 Answers  


What is coalesce and check constraint in sql server?

0 Answers  


what is the maximum size of a row in sql server 2000 and 2005

2 Answers  


What is the use of tempdb? What values does it hold?

0 Answers   Abacus,


What are types of subqueries?

0 Answers  






Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,


How important do you consider cursors or while loops for a transactional database?

0 Answers  


Explain how to use linked server?

0 Answers  


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  


Explain data warehousing in sql server?

0 Answers  


What is transcation?Plz give One example?

2 Answers  


How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  


Categories