This post is not long enough to be a fully-fleshed out post on my technical blog, so I'm putting it here. Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server by Joseph Pilov is a worthy read if you're at all interested in how query plans are built.
The local SQL PASS chapter in Calgary is hosting yours truly as the speaker for this month. I only have an hour, which I will easily go over, to talk about how I make SQL Server go faster. The talk is titled "The Database is Slow" (The SQL Server Performance Tuning Starter Kit), and I'll … Continue reading I’m speaking again
For the next two weeks, I'll be spending time with the SQLskills.com gang again, this time for IEDev and IE4. It's all very exciting! The hotel has even put me on the ground floor so that I don't have any stairs to contend with.
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
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
Today at the clinic, we did the second of three phases of network reorganisation. In the first phase, which we completed a week ago, our new server was set up with the EMR software, all data was migrated from the old server, and the vendor remoted in to make sure everything was up and running. … Continue reading What I did today
My boss convinced me this week to demo the new features in Microsoft SQL Server 2008 R2 to our team, so that they can get a basic handle on why I think SQL Server 2000 should be buried. The big day is on 27 January, and I have 45 minutes in which to make the … Continue reading SQL Server 2008 R2 demo