There is a shared lock (S) on the data, but that prevents exclusive locks being placed on the page/row/table for changes. It doesn't impact read performance.

As you noted the data...

Ugh. Tim Mitchell had something similar that he did in a presentation to skip headers when using SSIS, but you could easily redirect the headers to another table, as Sean...

I don't think there is a way to do this. You could make a SQLCMD batch file and use that.

I thought that you could specify the default db location in setup and all databases went there, including system ones.

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