Viewing 15 posts - 18,256 through 18,270 (of 22,214 total)
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
Nothing. Sleeping & dormant processes are ones that are still working. The real thing to look for is blocked or blocking processes. If none of those, then you need to...
February 20, 2009 at 7:42 am
Bob Hovious (2/20/2009)
February 20, 2009 at 7:40 am
Jeff Moden (2/20/2009)
February 20, 2009 at 7:37 am
Viewing 15 posts - 18,256 through 18,270 (of 22,214 total)