The latest version of sp_WhoIsActive (and apparently last for SQL Server 2005/2008, according to Adam Machanic), was released a week ago. Yesterday, out of curiosity piqued by my recent three-week SQLskills training, I decided to run sp_WhoIsActive while doing a DBCC CHECKDB on a moderately large database (mainly because it takes longer, so it's easier … Continue reading Adventures in @BlobEater, sp_WhoIsActive and DBCC CHECKDB
When setting up a virtualised clustering environment, using a base install of Windows that you want to clone for use later, remember to run sysprep BEFORE cloning. Thanks to James for pointing out the glaringly obvious.
I've finally got all four virtual machines required (per Jonathan's blog series), up and running on my laptop, and it is taking serious strain. I'm inclined, in fact, to change all the machines from 2 vCPUs to a single vCPU each, because that's what's killing the machine. Then again, I never considered until February 2012 … Continue reading My laptop is crying
A week ago, I had just returned from a three-week sojourn in sunny Tampa, where I spent most of the time indoors, far away from the sun, relearning everything about SQL Server. Those three weeks are best summarised in my previous blog entry, where I described Immersion Event 1. The result was that I wanted … Continue reading And he’s back …
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many respects, in that SQL Server 2000 does not support included columns, nor disabled indexes, so the scripts themselves were straightforward. … Continue reading Remove duplicate indexes in SQL Server 2000
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because they are based on DMVs and catalog views built into SQL Server 2005 and higher. With her permission, I have … Continue reading My brain hurts
There are words that can accurately describe how I'm feeling right now. These would include exhausted, drained, tired, sleepy, somnolent, and soporific. Then there are other words that can describe my state of mind, which would also be accurate: inspired, grateful, excited, awed, amazed, and invigorated. The latter have resulted in the former, and while … Continue reading My first week of three with SQLskills Immersion Events