Viewing 15 posts - 48,301 through 48,315 (of 59,064 total)
Wow... even those seem pretty long. Maybe it's cache on my machine. I've not checked but it was advertised as a "server quality" mother board with lot's of...
September 13, 2008 at 6:45 pm
garethmann101 (9/13/2008)
Heh... understood. But, now that you've said that, it makes you also wonder if they're cognizant of the damage they could cause. If they don't know how...
September 13, 2008 at 6:29 pm
Hey Upperbognor!
This is an unusual method of "ranking"... From the looks of things, most folks haven't heard about it. You should write an article about it for this forum....
September 13, 2008 at 5:57 pm
I don't know if it'll help performance at all, but there is one more "eyeball" optimization you could make...
Using the 2007 code (which would also apply to the equivalent...
September 13, 2008 at 5:50 pm
Nice article, Jack... good code example, too!
On the subject of "Why the hell would they do that?", I've found that Microsoft set's the default for databases to ANSI_PADDING OFF using...
September 13, 2008 at 5:26 pm
You said in a previous post that the filename was just "EmptyFile"... you can't have 3 files in the same directory names "EmptyFile". And, no matter what it's called,...
September 13, 2008 at 5:01 pm
Now you're scaring me! 😛 I wonder if VM's have a problem that way? I've gotta test this at work on Monday... we have some identical boxes some...
September 13, 2008 at 4:49 pm
Hey, Bob Bridges! You still there? Has any of this helped?
September 13, 2008 at 4:44 pm
Oh hell... so long as I'm being self-indulgent...
[font="Arial Black"]Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays[/font]
http://www.sqlservercentral.com/articles/T-SQL/63003/
But, what I'd really like to know is what I've asked a couple...
September 13, 2008 at 4:42 pm
Thanks, VERY much for the timings. The IO is certainly a much appreciated bonus.
Also, thanks for the detailed explanation of the "loading" required for your task... the kicker was...
September 13, 2008 at 4:38 pm
bitbucket (9/13/2008)
True enough... my question is why you'd want to do anything to all tables from outside the database when the database does it so well?
Jeff: I am taking...
September 13, 2008 at 4:32 pm
Actually, there's a bit of confusion about what a "DBA" actually is...
There are "Systems" DBA's who may come close to not knowing how to write any code other those...
September 13, 2008 at 4:19 pm
Domagoj Orec (9/13/2008)
I've run your code on my machine, core2duo E8400 with 4GB of RAM and this is what I've got in...
September 13, 2008 at 3:39 pm
Viewing 15 posts - 48,301 through 48,315 (of 59,064 total)