SQL Server 2005 Native Client is not getting installed at the time of installation of SQL Server 2005 over 2008. I am thinking that as all ready the earlier version...

Thank you for your reply.

Jags

Jeff,

You are absolutely correct. Tuning of Inserts is as Important as Tuning the Selects.

so i want any options or any types or any methods or any scenarios to Tune...

Thank you for the answer.

Jags

Thank you for your reply.

What exactly my question is....

Scenario 1:-

if we are selecting some 10000 records in a praticular table with out an index it take some 10 to 20...