This is a question that comes up a lot – how to run consistency checks on a VLDB? We’re talking hundreds of GBs or 1
Here’s a question that came up yesterday in our chalk-talk on database mirroring at TechEd IT Forum that Kimberly and I talked about this morning (here
In my previous post on interpreting DBCC CHECKDB output, plus in my DBCC Internals session at TechEd IT Forum in Barcelona yesterday, I mentioned there
This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so
One of the sessions we did yesterday at IT Forum was an Instructor-Led Lab on database snapshots, an Enterprise Edition feature of SQL Server 2005.
Last week at SQL Connections someone said that CHECKDB’s output is ‘useless’. Given that I wrote CHECKDB for SQL Server 2005 I was only mildly
This is a question I was asked multiple times over the last week: the Microsoft guidelines for database mirroring say not to mirror more than
A couple more questions from the last couple of classes. Q1) Why doesn’t performing an index rebuild alter the fragmentation? A1) Here are the possibilities
This is a question that came up yesterday in our Disaster Recovery class so I’m typing it up in between attending sessions at Microsoft Day
Sitting here in our Disaster Recovery class at SQL Connections and Kimberly’s on till lunch so I’m banging out a quick blog post covering the
Quick post this morning before this gets knocked out of my head by the Disaster Recovery session we're doing today at SQL Connections. This came
As promised, here’s the first of the grab-bag of questions we were asked during conferences. I’m blogging a selection of the stuff I noted down. These
This is a quick answer to a question I was sent today by someone who’d read Kimberly’s partitioning whitepaper – Partitioned Tables and Indexes in
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.