Moving a Multi-TB Database From One Disk To Another
Recently a client brought me a challenge. They wanted to more a database from one LUN to another. So far this is pretty straight forward. The trick here is that this is a multi-TB instance with several databases which are about 1TB in size, and the instance has a two hour per night maintenance window. […]
Recommended Reading for November 14, 2014 by mrdenny
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Trace flags – TF 7806 Writing Fair and Useful Editorial Reviews Is Hard Work PASS Election Results for 2014 Script to generate index rebuild with PAGE compression A Partitioned Table May Limit […]
PASS Speaker Idol 2014 Review and Notes
This year the SQL PASS conference held their first Speaker Idol contest with the goal of getting new speakers into the PASS Summit on the strength of their presentation skills instead of their abstracts. And I think I can safely say that it was a resounding success. We started with 40 people who applied (38 […]
Recommended reading from mrdenny for November 07, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. MacGyver Moments Ask Slashdot: Is Running Mission-Critical Servers Without a Firewall Common? The 2008 R2 Bug Fix That Breaks RCSI A Partitioned Table May Limit the Runtime MAX DOP of Create/Alter Index […]