Lynn Pettis (3/22/2012)

---

Glad you agree, because I went back and read through everything again to see if I could figure out where I got annoyed. It was after he...

kaspencer (3/22/2012)

---

Why is the number of errors in Questions of the Day so great?

How are we supposed to interpret typographical errors?

I have yet to build the stored procedure SP_ESP so...

My apologies for the question. Yesterday was a holiday for me, so I'm getting back today.

The typo is corrected, and thanks to all who pointed it out. Points have been...

Randy Rabin (3/21/2012)

---

Oh, and Steve - I clicked on the little graph above your post expecting to see some relevant data. Took me a minute to realize the time frame...

Hmm, just ran a test db, in compat mode 80, and CROSS aPPLY works, as does a select from missing_indexes.

SQL2K8, SP1

CREATE DATABASE sql2kCompat

;

go

ALTER DATABASE SQL2KCompat

SET COMPATIBILITY_LEVEL =...

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...