Viewing 15 posts - 51,646 through 51,660 (of 59,072 total)
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...
March 18, 2008 at 4:05 pm
Since it's a PDF file, maybe save it in an IMAGE datatype in 2000 instead?
March 18, 2008 at 3:54 pm
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...
March 18, 2008 at 3:43 pm
Here's both an answer to your current dilema and what to watch out for in the process...
March 18, 2008 at 3:38 pm
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...
March 18, 2008 at 3:23 pm
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...
March 18, 2008 at 3:15 pm
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...
March 18, 2008 at 3:04 pm
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...
March 18, 2008 at 2:46 pm
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). 😀
March 18, 2008 at 2:33 pm
Chris Morris (3/18/2008)
Jeff, you like playing with macros in Excel
Heh... no I don't... I hate the darned things... That's why I like the second of my two methods the...
March 18, 2008 at 2:29 pm
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...
March 18, 2008 at 12:44 pm
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
...
March 18, 2008 at 12:32 pm
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...
March 18, 2008 at 12:20 pm
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...
March 18, 2008 at 12:05 pm
Viewing 15 posts - 51,646 through 51,660 (of 59,072 total)