Viewing 15 posts - 43,531 through 43,545 (of 59,063 total)
GilaMonster (6/6/2009)
WayneS (6/6/2009)
You know, it's always those complex T-SQL concepts that trip up so many people.Good going Gail!
I know. Those darned updates are just so hard to understand. :hehe:
Correct link...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2009 at 8:56 am
GSquared (6/5/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2009 at 8:43 am
Paul White (6/6/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2009 at 8:41 am
Amazing... what the hell did the boys in Redmond do? The code posted above by arijit works just dandy in 2k5. The error appears when you try it...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2009 at 12:14 am
keywestfl9 (6/5/2009)
region will also be a parameter
Heh... I knew that. What do you want done with it? You didn't list it in any of the conditions you've laid...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2009 at 12:07 am
Depending on what you're doing, FLOAT can be great. For example, if you add 1/3 three times, you should end up with a nice solid "1", right? Well,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 11:13 pm
Dear RedGate,
I absolutely agree with what Ravi said except for that being the only missing functionality. Code windows that actually work correctly with Internet Explorer would be nice, too....
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:56 pm
I don't know the answer to your question, but I'd love to see your trigger code for this. I've always had a bit of a problem with InsteadOf triggers...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:52 pm
The easiest way to do this is to create a file in advance with the headers in it. BCP the data out to a separate file. Use the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:47 pm
No, you where clear. You just didn't think I was. 😉
Which do you think will be faster if you have 5000 files with 5000 lines each for a total...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:44 pm
I don't know if it'll be overkill for what you're trying to do, but this will certainly let you know what's going on with your tables. Think of it...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:34 pm
DBCC UPDATEUSAGE(0) is all you need to run before you run the script you built. It'll take a little while to run if you have a huge database but...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:28 pm
dave b (6/5/2009)
It will always be: * " ; Serial" with any given amount of spaces or tabs between the date, semicolon and "Serial."
Do you have to keep those...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:11 pm
Heh...
What I have found is that whatever managment thinks is "sexy" will get the dollars. That usually means GUI dev tools or some chunk of hardware with lots...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 10:04 pm
I agree with Vinay... sounds like someone set the growth limit on TempDB.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 9:12 pm
Viewing 15 posts - 43,531 through 43,545 (of 59,063 total)