AW2008 is filestream enabled, so if that's what you need, use that. If you want to avoid FS, go R2 or 2010.

Rod at work (3/20/2012)

---

Gail, I've seen job postings like that, too, where such a person would be a superman/superwoman, if they knew well all of the skill sets listed. ...

I tend to agree with Anthony, but a few more things.

Don't delete old backups until the new one is made, so take that into account.

In terms of backups, are you...

I tried it for a couple weeks, but it just seemed like I got some slightly...

Looks like the site isn't updated and you have to call MS to get a price.

US: (800) 426-9400

Canada: (877) 568-2495

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