Congratulations to Jeff. He is an excellent choice as the recipient of this award.

They need at least one copy of master, model, msdb to start. It might give errors with the various databases, but once it starts, you can then do a restore...

jay holovacs (9/14/2011)

---

Lempster (9/14/2011)

---

...Application vendors are not terribly helpful either - try finding any documentation where it specifcally states what permission is required on a given object. Most of the...

This problem with the question is entirely my fault, not Ron's. I copied over the code, making a mistake after testing it when I was correcting formatting. The second set...

Congrats, Jeff! I'll owe you a beer at PASS.

SQL Kiwi (9/13/2011)

---

...

I don't disagree at all; though that so many professional DBAs don't 'get' partitioning (a new feature in 2005!) is a bit depressing. Luckily, it seems 'commodity' DBAs...

The app definitely needs to be in the cloud, or it needs to be mindful of bandwidth.

Regarding combining data sets. I can think of a few ways to do this....

GSquared (9/14/2011)

---

Approximately 46.2-million Americans are in poverty per Census. Per Agriculture, 83% of those report having enough food to eat. That's still 17% reporting not having enough. ...

Sorry, corrected my statement. I meant to say lower charges for current rather than historical data.

Jo Pattyn (9/13/2011)

---

Cons: strain on your internet connection. What if the cloud decides to vaporize...

If so, what is the issue? SQL doesn't care where you have these columns stored. It isn't...

Let's another thread for a debate on that. I'll open one up in this forum.

http://www.sqlservercentral.com/Forums/Topic1174524-373-1.aspx

If this is for queries, then you can do this as well:

select

Fname

. Lname

, DOB

, Age

, City

, Country

from Mytable

If its' for...

You can right click in the upper left cell of the headers in results and select "select all" and then "save as". You'll get a CSV loadable into Excel.

I like Flo's approach better since it allows you to better error handle things and I think dynamic SQL is harder to read for anyone else following in your work.

I am with Gail. A backup of the system, and SQL binaries, assumes that those are static. But those binaries get information from the system database in order to start....