Actually, MSDN is NOT wrong. You cannot make the primary filegroup read-only. This is actually a restriction on ANY database.

You can make the whole database read-only however.

So, this...

Even if you put the model db in read-only mode, any new databases you create will NOT inherit that property.

I assume this holds true for tempdb but I haven't tested...

Last one I received was Monday but, according to this archive page, there haven't been any since then. Not sure why?

Thanks for the feedback Melanie. I've received Friday's and Monday's newsletters so hopefully it looks like whatever issues you were having have now been fixed.

Not sure if they've fixed something but I got my newsletter today. Will see if they continue next week...

P.S. I'm in UK too.

You CAN change the default backup directory using SSMS very easily:-

- From Object Explorer, right-click on the server and choose Facets.

- In the Facet dropdown, choose Server Settings.

- Change the...

paul.knibbs (1/26/2011)

---

There are more possible ways a two-disk failure could take out RAID 0+1, so by the law of probabilities you're more likely to lose your array from a two-disk...

James Lean (1/26/2011)

---

In RAID 0+1 you have two stripe sets that are mirrored, therefore you could theoretically lose all of the disks from one of the stripe sets and still...

I have always been under the assumption that both of these RAID levels can tolerate the same number of failed disks; in theory you can lose up to half the...

Chris, I'm sure you know by now not to trust everything you read in BOL! 😉

Agreed, I can set model to read-only on 2005 and 2008.

Good question though, I was unaware these limitations existed.

For some reason, I've come in this morning and it's now working! No idea what happened there.

Thanks for the response anyway.

Thanks Hugo. That would seem to be a very specific case, I wouldn't have thought it was a good reason to make a general case for using COALESCE over...

Do you have a supporting link or further information on the performance difference between ISNULL...

No probs, thanks for your input. The database in question has been online for a couple of weeks now and no sign of any issues; I just thought I'd...