If you have systems center, or an equivalent, or want to do WMI scripting, you can probably initiate scans across your various Windows hosts to get a list of all...

I think learning those obscure items, and understanding those can make life richer and more interesting. I'm surprised sometimes how things from other subjects impact the way I look at...

There are a few ways to handle this.

The easy way is to use SQLCMD and a little scripting to connect to each database in turn and run a script.

One is...

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