Viewing 8 posts - 1 through 8 (of 8 total)
The editorial mentions that "we haven't yet built a good, easy to understand framework that provides good monitoring and auditing in a way the majority of DBAs can understand and...
May 8, 2012 at 12:35 pm
While I've had more than one employer that's been reluctant ("loath") to provide training resources to employees, I'm not sure I have worked for any that truly hated ("loathed") it.
April 9, 2012 at 8:04 am
Great topic. I think there's a perfect metaphor around highway interchanges. I particularly like this description of so-called stack interchanges: "This is not only expensive but also creates an eyesore...
February 27, 2012 at 11:45 am
Turns out I may have found the answer, unseemly as it may be. The error message appears to be bogus. The developer went back and checked the stored procedure and...
June 18, 2009 at 1:21 pm
I think I've found a workaround that might be useful to some of you. After deciding I didn't want to completely uninstall my SQL Server to get replication working, I...
March 23, 2009 at 12:59 pm
I just spent the better part of a day researching this. Here's my scenario and what I fear is the outcome.
- My development server is SQL 2005 Standard Edition with...
February 11, 2009 at 1:35 pm
Marker - Further to DavidB's reply about DEFRAG v. REINDEX, if you are running SQL Server 2005 search Books Online for this:
Using sys.dm_db_index_physical_stats in a script to rebuild or reorganize...
December 24, 2008 at 11:54 am
You may want to look into the script posted in this Microsoft support article:
http://support.microsoft.com/kb/256650
While the article refers specifically to SQL 7.0, I've used it on SQL 2000 and believe it...
November 5, 2008 at 8:14 am
Viewing 8 posts - 1 through 8 (of 8 total)