DECLARE @EndTime DATETIME

DECLARE @StartTime DATETIME

SET @StartTime = GETDATE()

--... code here to be measured for duration

SET @EndTime = GETDATE()

PRINT...

Dunno if it's any of these... see attached... might be DBCC Buffer or DBCC ProcBuf.

I found it... it's an article on this forum by a good fellow by the name of David Poole... I had it in my "favorites"...

http://www.sqlservercentral.com/articles/Administering/utilityprocedures/2272/

kumar99ms (3/16/2008)

---

Thanku for response

could plz tel me is there another way to find out dead lock

How can i rectify this deadlock

Which situvastion it will occure

Blocking and dead lock which...

The fastest method is neither... the fastest method is BULK INSERT. I don't use SSIS or DTS, but rumor has it that SSIS has a "BULK INSERT" object that...

Absolutely... I have the steps to do it somewhere but it's been a 1000 years since I've done it... let me look for it...

I agree with Sergiy... and, if you use SELECT INTO, you will have about 58 minutes left to ensure the FK's have been correctly instantiated and to do some regression...

Lisa Slater Nicholls (3/16/2008)

---

>>

Before you use any of those that have a self join or correlated subquery that use the ">=" or "<=" or any other inequality method to...

Ok, folks... I was operating on some old experiences with correlated sub-queries... Hugo and Barry's posts made me look deeper and, after studying the actual execution plans in both SQL...

Heh... How often I've been bit by the infamous timeout on this forum... I too have learned to at least do a {CTRL-A}{CTRL-C} before I hit PREVIEW or...

Thanks for the feedback, Anvi. What's even better than my humble article is what folks have to say in...

Great... Barry gets the "A".

My bad, Tracey... I said in my post that I was "Running 2k sp3a"... not a real obvious note on my part... sorry and thanks for the idea.

Barry, thanks for...

I do understand your passion about it and thanks for...

DAvid (3/15/2008)

---

I am surprised (being introduced to other DBMS before SS) that the location of the predicate relating the summarised aggregate sub query and the table for update had any...