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
Explain indexes disadvantages?
What is coalesce and check constraint in sql server?
what is the maximum size of a row in sql server 2000 and 2005
What is the use of tempdb? What values does it hold?
What are types of subqueries?
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
How important do you consider cursors or while loops for a transactional database?
Explain how to use linked server?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Explain data warehousing in sql server?
What is transcation?Plz give One example?
How will you collect the date from current date to last older 6 days date in sql server 2005