Viewing 15 posts - 1 through 15 (of 66 total)
I totally agree, Mark's monitor is great for efficiently tracking individual DB's inside SQL. I get a little nervous modifying MSDB or running XP procedures so there is a little...
July 1, 2005 at 9:51 am
Thanks for the script Rcarlson! It doesn't quite do the same thing but it is more useful in general (non sql server administration). I think I'll parameterize the inputs so...
July 1, 2005 at 7:57 am
Sadly I gave up and 'rolled my own' notifcation service for this particular app. If you find a solution please share! I've been thinking of giving another try pretty soon.
June 27, 2005 at 8:17 am
Agreed...it would have been interesting to see his schema/logic modifications and cleanup sequence. As is, the article isn't very useful.
March 23, 2005 at 7:30 am
I'm not sure how you plan on getting the file names converted to inputs to Bob's procedure, but you could combine his method in a DTS job combining some VBS...
September 7, 2004 at 8:45 am
Multiple CPU benefits depend on your application. Keep in mind that for licensing MS requires 1 license per processor (physical processor, not logical as case with hyperthreading). In some cases...
September 7, 2004 at 8:00 am
Thank you for your time and ideas. After Microsoft analyzed the issue and reproduced it on their end, this behavior was deemed a bug. The temporary work around is...
September 7, 2004 at 7:49 am
September 7, 2004 at 7:37 am
September 7, 2004 at 7:30 am
What tools are your clients running, or what are the specifics on how they connect to and use your db?
September 2, 2004 at 6:59 am
You might be going offline from your exchange server and Outlook just builds the emails up in the outbox. You might be able to set Outlook to stop going offline.
September 2, 2004 at 6:54 am
Would executing a transaction log from several days of prod activity against the test database work to simulate this load? Just a thought. I'm still confused on how to simulate...
August 30, 2004 at 9:42 am
Well, with the inner join syntax the proper efficient execution plan is always chosen so this syntax wouldn't help me. Is there a way to use the hash hint with...
August 30, 2004 at 9:41 am
My server load include updates, inserts, selects, deletes. Would I just be simulating selects? It seems that the other operations would cause data constraint violations. If I'm just doing selects...
August 27, 2004 at 2:14 pm
Thanks for the interest. I backed up prod and restored it to a test server. The slow behavior was not there. So I took the same backup file and restored...
August 27, 2004 at 2:11 pm