Anthony is correct.

It isn't master, but the way compat level works. It doens't make it a 2000 database. It's still a 2008 database, so all new features work. Backups, restores,...

Lynn Pettis (3/21/2012)

---

Some people. Let's report a problem trying to save changes from the UI but able to do it with an ALTER TABLE statement and ask if others...

The Google API we use sometimes flakes, not sure why.

If you use Prakash' suggestion, that should work.

I would think it's more when you see a benefit, or when you see you have a significant amount of queries that only access a subset of your data. So...

David.Poole (3/21/2012)

---

The cloud as it is at present isn't the solution. It may be able to store exobytes and beyond but try accessing that amount of data. I've...

Rod at work (3/20/2012)

---

Intriguing article, Steve, I'm going to follow this discussion with interest. I've only one, tangential thing to add; I've never gotten a job in the prescribed...

Love to say I'd do something I love, never know. Hard to knock Pettite, but until you've walked a mile in someone's shoes, how do you know?

I say good for...

Pettite is a nice insurance possibility. I'd like to see him work out, throw, take it easy overall, come up for injury, but be available in the post season. He's...

I don't have a 2005 instance handy, but usually the paths come out of the backup file, not the database you're restoring over. This usually means that you need to...

SQLRNNR (3/19/2012)

---

Steve Jones - SSC Editor (3/19/2012)

---

Finally read The Hunger Games on Sat since my son desparately wanted me to read it before the movie comes out. It was pretty...

Lots of people say tabs because it's less typing. You can configure tabs to be entered as spaces. I wouldn't think the typing is that big a deal then, especially...

A database backup never looks at the instance. It doesn't know that it was taken on the "SalesDBServer" instance. It just knows that it was the "Sales" database, and it...

I'd agree with Lynn that you might want to look at 2012 AlwaysOn.

In terms of cluster + mirror. Clustering gives you instance protection from anything except disk failures. Mirroring does...

Solomon Rutzky (3/18/2012)

---

chrisn-585491 (3/18/2012)

---

Given the many CTPs and RC0, it doesn't make much sense anymore to wait. Yes, there will be bugs but that doesn't set it apart from any...

Finally read The Hunger Games on Sat since my son desparately wanted me to read it before the movie comes out. It was pretty good, and quite the page turner....