No idea what a contained database is, so I had to guess today! I'm sure someone will write an article soon? 😀

If the question is wrong, it should be corrected and all points removed, so people get another go.

QOTD is a great way for learning snippets of SQL Server, so long...

Just had this on my shiny new SQL 2008 R2 box, with the very first job I have set up (a backup of the sysem databases)!

All the case settings 'look'...

Mohit K. Gupta (5/1/2009)

---

If you are just using non-clustered indexes and heap; it will first cause a RID Lookup anytime you access anything in that table via a Index Seek....

A great article - my only concern is that out production database is replicated to two other servers and log shipped to a third, so you couldn't use this process...

I am just starting to set up SQL Monitor to monitor a clustered server, so I'll see if I get the same problems you had with registering the server.

Good question - we've been hit by this problem too and it can be a right pickle to sort out!

Never heard RAD10 called RAID 1+0 before so I learned something today. Thanks.

A very interesting article, which has stirred up some great debate. I know use BEGIN TRANSACTION whenever running updates - even on test.

What would be great is an easy way...

Nice one - looks like I was one of many who didn't realise you could restore at the page level. I'll certainly look into this as it's the kind of...

I think it would have been clearer if the question mentioned Binary in the title or Differences between SQL 2005 and 2008. Looking at the code I had no idea...

Thank you for a great reminder that disk space isn't free! We installed a new SAN at the start of 2010 and it is already full - and I'm sure...

Nice Question - it's worth understanding this before you write UPDATE statements that you would expect to work in a procedural language, where the value of col1 would be overwritten...

I haven't noticed datetime2 before so thanks to the author for bringing this to my attention. I can see it would be useful in some scenarios.

I also got 1,2,3,4 so not sure what the question was trying to show - no bug here!