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 do you make a trace?

1015

Can we update data in a view?

1021

What are the advantages of the mirroring?

1081

Are resultset updatable?

945

How to locate and take substrings with charindex() and substring() functions?

1010

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

945

What is an expression in ms sql server?

1066

what is a sub-report?

140

What is the function of inner join?

1064

Explain the cursor lock types?

1046

what are the new features introduced in sql server 2000? : Sql server database administration

909

What to check if a User database is locked?

1060

What are the results of running this script?

916

In what version of sql server were synonyms released?

936

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1013