Heh... the first indication of a problem would be the 1 or 2 hours that it originally took never mind the 6-8 it's taking now! 😉

You wrote...

The DTS queries...

Since it's a PDF file, maybe save it in an IMAGE datatype in 2000 instead?

Don't waste your time on that... answer a quick question instead...

Triggers fire on any update... If I update a name from 'Jeff' to 'Jeff' (not a type-o, they are the...

Here's both an answer to your current dilema and what to watch out for in the process...

http://www.sqlservercentral.com/articles/Test+Data/61572/

I think you may have a misunderstanding of what it does... VarDecimal has nothing to do with the MONEY datatype. The only time that VarDecimal saves space is if...

Did you look at the "Message" window? Sometimes one or the other runs in half the time as the other. Some folks look at something like that on...

Perfect... the next thing to do would be to practice a little of what we call "forum etiquette"... 😉 How did you solve it and would you mind posting...

Heh... No doubt... I can see the RBAR on steroids now... some of my favorite misuses are SPLIT/CONCATENATION functions in batch code, UDF's that format dates so they can be...

And then you better make sure you run the code more than once, even on a quiet system...

DECLARE @Year INT

SET @Year = 2008

SET STATISTICS IO ON

SET...

LMAO!!! ROFL!!! Now that's funny stuff... I don't care who you are, ya gotta laugh at that! (Thanks for the quote Larry TCG). 😀

Heh... no I don't... I hate the darned things... That's why I like the second of my two methods the...

I agree with the others... find and fix the problem... and, Know this... Setting the Transaction Isolation Level and using WITH (NOLOCK) is NOT a panacea for fixing deadlocks.

We were...

Sorry... forgot to add the line that makes it more than twice as fast...

DECLARE @Year INT

SET @Year = 2008

;WITH cteDates AS

(

SELECT DATEADD(yy,@Year-1900,0)+Number AS TheDate

...

Matt is absolutely spot on. Without actually getting into using a Tally table to do this, here's one way to programmatically generate a Year's worth of dates using a...

Just my 2 cents... I'm always pretty much amazed at such requests... I do one of two things in most cases where someone "has to have it" in an Excel...