One of the things we have found when doing maintenance is to make sure no jobs kick off in the middle of our manual maintenance tasks. SELECT * INTO msdb.dbo.sysjobs_temp FROM msdb.dbo.sysjobs UPDATE msdb.dbo.sysjobs SET enabled = 0 Then, when you are finished: update sj set sj.enabled = sjt.enabled from msdb.dbo.sysjobs sj join msdb.dbo.sysjobs_temp sjt [...]
Continue reading about SQL: When doing maintenance disable all jobs…
If you are re-attaching databases after a SQL 2008 upgrade, here is a quick n dirty T-SQL command to upgrade to the the correct compatibility level, just run, copy the results and run those: select ‘ALTER DATABASE [' + [name] + ‘] SET COMPATIBILITY_LEVEL = 100′ from master.dbo.sysdatabases
I am currently looking for some books to read to try to get to my goal of a book read a week… I have a bunch of Young Adult fare as I used to work at a library and I find the genre fun to read. I have a lot of licensed material (Star Wars [...]
Here it is: And an Amazon link (yes, I am trying to monetize )
Yea, I know, everyone has these and the probability of actually keeping them is low… I am going to set my expectations high so I can either strive to succeed or be happy with partially succeeding Blog daily (already missed yesterday, but we will try). I want to say something everyday to get myself into [...]
DandyID
AIM
Amazon
Digg
Ebay
Facebook
Flickr
Google Reader
Gyminee
Hulu
iTunes PodCast
LibraryThing
myOpenID
Netflix
Odeo
Plaxo
Shelfari
Stack Overflow
Stumbleupon
Twitter
YouTube