Next week I am heading to Seattle for 5 days of SQLskills training. In honor of the event (yes, I’m that excited about it and I’ve deemed it an event), I thought I’d do 5 days of posts covering what I’m looking forward to and why. I. The Content For anyone not familiar with SQLskills and…
Category Archives: Performance
A case of slow performance on Windows 2008 R2
Windows Server 2008 R2 was released in 2009, but we still have many customers on Windows 2003 (and probably some on Windows 2000 I’m sure). I’ve run into an issue with two customers when they upgraded their SQL Server and Windows version at the same time, and thought I would share the details in case…
Meme Monday: I got 99 problems but a disk ain’t one
Last month Thomas LaRock ( blog | @SQLRockstar ) started a series called Meme Monday, and this week the task is to list nine things that can wrong with SQL Server that are not the result of an issue with the database file storage. Note: The emphasis on nine reminds me of a quote from…
Found: Rows from a Merge Join
About a month ago I blogged about an issue I had with a customer where a search in one area of our application returned less data than expected, and a search in a different area of the application returned the proper amount of data. I was able to work around the issue by dropping a…
