i think above 2 answers arent much betr.wil try to give perfect answer so

What are the factors you will check for the performane
optimization for a database query?

Question Posted / bata

Answer Posted / bata

i think above 2 answers arent much betr.wil try to give
perfect answer soon

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to get the number of affected rows?

952

What is the syntax to execute the sys.dm_db_missing_index_details?

970

Explain various On-Delete options in a DB table. Which is the default option?

1406

Mention the different authentication modes in sql server.

966

How to verify the port number of the sql server?

1042

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

911

How do you create a data source?

870

What is a performance monitor?

923

What is buffer cash and log cache in sql server?

1056

What is a scheduled job or what is a scheduled task?

916

What are the pre-defined functions in the sql server?

1031

How many instances per computer are there in sql server 2000?

1010

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1016

How many types of triggers in sql server?

972

How to sort query output in descending order in ms sql server?

903