Viewing 15 posts - 18,241 through 18,255 (of 22,202 total)
But that example compares one thing you shouldn't do, SELECT *, with another thing that has serious enough costs that it almost needs to be in the shouldn't do category,...
February 20, 2009 at 1:08 pm
Putts (2/20/2009)
Are there certain cases where...
February 20, 2009 at 1:05 pm
josephptran2002 (2/20/2009)
I have 4 tables such as BOCLEARED, CTCLEARED, NHCLEARED, and TOTALCLEARED.
In table BOCLEARED (given), it includes 3 columns such as
DDS BOCLEARED...
February 20, 2009 at 12:50 pm
Add a hearty "me too" to everything Steve said.
This was just posted on Brad Magehee's blog today:
February 20, 2009 at 12:34 pm
From the sounds of things, not everything is in the same database. I'm not sure that's a mistake or by design. In general, if you're getting an error that says...
February 20, 2009 at 12:23 pm
Putts (2/20/2009)
My view, with no WHERE clause, will return millions of records. With the WHERE clause being used it's narrowed down...
February 20, 2009 at 12:20 pm
Steve Jones - Editor (2/20/2009)
Thanks, grass....That always gets me a chuckle. I think you might need a dual rotor chopper for that mission!
It should give you a chuckle, Champion. Tunnel...
February 20, 2009 at 12:06 pm
Putts (2/20/2009)
The view is a source to a report. The application works in this manner....
1. User selects report...
February 20, 2009 at 12:05 pm
Lynn Pettis (2/20/2009)
Newbie alert!Think we should try mounting a rescue mission for bvaljalo?
No, I'm enjoying the show. I'll dive back in a bit, maybe. Also, it's possible my bozo bit...
February 20, 2009 at 12:02 pm
Hmmm. I've never run 32 bit SQL Server on a 64 bit machine. Seems to kind of defeat the purpose. But anyway, I don't know the answer to the problem....
February 20, 2009 at 11:59 am
Lisa Phillip (2/20/2009)
Sparse columns REDUCE the space needed not negates: Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values.
Yep. I...
February 20, 2009 at 11:18 am
More information please. Performance counters do work. Are missing all of them or one specific one?
February 20, 2009 at 11:09 am
Robert Davis (2/20/2009)
The...
February 20, 2009 at 10:42 am
Bob Hovious (2/20/2009)
I'll drag in another alternate universe and say deploy the thopters to fetch him back before he is devoured by the shai-hulud.
Huh, really? I would have thought that...
February 20, 2009 at 9:34 am
I'm with Bruce. We drop & recreate the indexes when there are massive inserts every night. It usually speeds up the process and you don't get fragmentation.
February 20, 2009 at 8:22 am
Viewing 15 posts - 18,241 through 18,255 (of 22,202 total)