NONE. DBCC Commands are resource hungry and can cause locking issues DBCC reindex for example. Recommend you have a full set of backups and your...

Ummmm seeing as you can't detach system databases you can't do it to Master. And if you are trying or needing to you are in a whole world...

You must start this process from the last full backup, remenber set the option to 'Restore with no recovery' This is the starting point. You must...

I Need to post a retraction

On further research and reading of Fowlers' Common English usage circa 1926 - reprinted 1954 makes the clear distinction on the correct and acceptable usage...

Dim myMessage

And heaven forbid that I use "Bonza" "bewdy" or Aussie in a sentence. or etc because I can't spell the other or BTW 'cos I have to compress it...

Clip from Editorial

"Whether we standardize on English .." Ummm there is no 'z' in standardise and there is a 'u' in 'Color'. And there are several usages of there,(mostly...

Tuning being the topic and DBA's seem to be the target. Sorry, but umbrance taken. As a DBA it mostly falls to me to do the...

But..... if we had Psychics coupled to brainwave imaging ... Oh that's been done too !;)

BTW what a boring existance it would be if we could determine from...

The great software houses have forced the "User Experience" on us, and Open Source is only "Open" to a select few and "In-House" development can be an incestuous relationship between...

Interesting posts and all very valid. My 'two cents' worth ....

Degrees like MS certifications show you have the ability to retain, process and hopefully apply information. ...

Probably a bit late, but hey, just love Chess. I play chess in it's many variations. For those who like the Idea of Chess but find it too...

Thanks Patrick, There are many ways to this end. Yours.... simple....effective....to the point.

Awesome !!

CodeOn 😛

Absolutely K,

Credit where credit due. But there will always be those who don't care and I would like to think that...

Hey Bloggers all, I would like to offer MHO. These sites, unless I miss my guess is all about exposure. Yours. Comments are read and the...

Confused !!   Got the question wrong then checked MSDN and got this 

QUOTE

Hot Add Memory requires SQL Server 2005 Enterprise Edition and is only available for 64-bit SQL Server, and for...