Viewing 15 posts - 6,931 through 6,945 (of 14,953 total)
I think it would be useful to have a Comments "parameter" for the various create and alter DDL commands. If it could handle XML, that would be great. ...
March 15, 2010 at 6:35 am
The editorial refers to "this article", but it doesn't appear to have a link to the article referenced, so I can't judge that.
One of the key problems with information is...
March 15, 2010 at 6:26 am
Do you have a schedule that doesn't have times/days picked out or something like that?
March 15, 2010 at 6:22 am
CirquedeSQLeil (3/12/2010)
GSquared (3/12/2010)
I'm working on a book on my experiences with learning how to DBA. It'll definitely be written to take this kind of thing into account.
When do we...
March 15, 2010 at 6:18 am
RBarryYoung (3/15/2010)
Thanks all! Well, off to the butchers... 😀
Good luck and fast recovery.
March 15, 2010 at 6:12 am
You can generate a lot of it programmatically.
Take a look at the definitions of the holidays. Most of them can be handled in SQL pretty easily.
Some are dead easy,...
March 12, 2010 at 12:34 pm
It might at least give you a hint.
Have you checked for a blocking process?
March 12, 2010 at 12:26 pm
Or don't even know where to look to find out if they have a good backup.
March 12, 2010 at 12:25 pm
I'm assuming you've checked the error logs for more details. What did those have?
March 12, 2010 at 12:24 pm
I've used it for large files, but not quite that large. Worked very well for multi-meg files.
March 12, 2010 at 12:23 pm
Can the query be broken down into smaller pieces to see what's taking so long? Like, if it joins multiple tables, query each table separately and see if one...
March 12, 2010 at 12:21 pm
CirquedeSQLeil (3/12/2010)
GSquared (3/12/2010)
But I think if we had a "Please...
March 12, 2010 at 12:19 pm
If we did the "Delusionally Thinks He's a DBA" contest, there would certainly be a lot of competition for that one.
But I think if we had a "Please God I...
March 12, 2010 at 12:08 pm
I use traces for that kind of thing.
March 12, 2010 at 10:12 am
When I need to escape from my cubical and get my mind out of burnout mode, I take a walk around the block. Sometimes takes a few laps. ...
March 12, 2010 at 8:30 am
Viewing 15 posts - 6,931 through 6,945 (of 14,953 total)