Viewing 15 posts - 52,006 through 52,020 (of 59,070 total)
You may have to do a DBCC UPDATEUSAGE on TempDB just before the sp_SpaceUsed to get that to change...
March 7, 2008 at 11:42 am
Correct... not worth it. And thanks for the feedback.
March 7, 2008 at 11:39 am
What? One row? You'll need to show me that URL... take a look at Books Online, instead... example they give uses SELECT TOP 1000 *...
March 7, 2008 at 11:32 am
I'm not so sure that's true, Adam. I believe you can use OPENQUERY for this.
March 7, 2008 at 10:52 am
Yes... there is another way using a triangular join... but it's horribly slow and relies on a unique or primary key and an order by...
To generate a running count in...
March 7, 2008 at 10:47 am
I'll see if I can resurrect the code I used tonight and share it here...
March 7, 2008 at 10:13 am
Heh... it wouldn't take as long to explain in person as it did here, Johan... I'd have just pointed out the couple of optimizations that everyone expects, explained that there's...
March 7, 2008 at 10:03 am
When all else fails, porkchops seem to work... 😛
March 7, 2008 at 9:54 am
MattieNH (3/7/2008)
March 7, 2008 at 8:27 am
I agree with Matt... EXISTS in the form of NOT EXISTS is used to find something that has no match in another table. EXISTS by itself should probably...
March 7, 2008 at 8:06 am
Brandie Tarvin (3/7/2008)
March 7, 2008 at 8:01 am
I have to know because it's a bit unusual... why do you need this type of sort?
March 7, 2008 at 7:49 am
Cool. Thanks for posting the solution!
March 6, 2008 at 9:31 pm
Viewing 15 posts - 52,006 through 52,020 (of 59,070 total)