We are considering set base apporch for new devlopment

but following is quite complicated SP, which i can not change now.

So please tel...

Few part is algorithm like loop.

and i want to roll back only if error comes any where in side outer loop,

and after error handeling i want continue with next id...

One more point is remaining.

I wanted to know the index ,statistic , etc recomendations made be tuning adviser is perfect or it is perfect to some percentage, as u said...

Thank u sirs ,

I will read those topics again from the books.

but if possible please write a word for use of (tsql vs trace) in Database Engine Tuning Advisor .

Finally...

If i can get pros and cons of each type of input to database engine tuning advisor then that will be help full?

(Any link will be help full)

yours sincerely

Thank you for links, i am brushing up .

Database Engine Tuning Advisor uses trace files, trace tables, Transact-SQL scripts, or XML files as workload input when tuning databases.

So please tel...

Please confirm

query no 1) and 2) will not get the benefit of alignment/collocation,

if i use them in exists or derived table?

yours sincerly

thank you,

but my question is still not answered.

yours sincerly.

yes i have cheked all possible things,

and finally came to conclusion that making one flat table would be good idea.

so all my queries are related to this flat table. and...

I am trying to get speed by making one table out of many table joins from queries.

and collocation is stroger form of alignment of partitioning (mssql 2005)

note:(I tried to change...