ya, i have seen them before, but they all are talking about with in "a transaction".

somthing like this

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

BEGIN TRAN

select * from wt

SET TRANSACTION...

As far as figuring out answer is concern i will find other answer to solutions,

but i wanted to know is sqlserver can run in this case or not,

"changing isolation...

is there any place where i can search it.

please send me link.

yours sinclerey

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...