two server can have same timezone and they can get updated from internet also, but will they keep same datetime uptothe second over time.

yours sincerely

Should i post it in any other category?

yours sincerley.

thank u,

I wanted to know , why msdn says to use it , though the excution plan shows some more task is done

when some .write...

In q1) I wanted to ask about...

1)

update t1

set a, b, c, d .f

from t1 a

join t2 b on a.poleid=b.poleid

join t3 c on b.t3id = c.t31d

where b.poleid =1

2)

update t1

set a, b, c, d .f

from t1...

ya bigger and smaller is number of rows.

yours sincerely

questions are inside Q1)Q2)Q3)

yours sincerley

Sir, I will do it)

my expectaion was, that i will get some thing written from microsoft.

so please send any...

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