Officially disguised as a Canadian
Author: RandolphWith 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 haveContinue 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 whileContinue reading My first week of three with SQLskills Immersion Events
For my 35th birthday, M took me on a Caribbean cruise, on the Allure of the Seas, from Fort Lauderdale to Labadee, Costa Maya and Cozumel. It was possibly the best holiday I’ve ever had, notwithstanding the awesome holidays I’ve had in the past. So without getting all gushy, I’d highly recommend this sort ofContinue reading Still cruisin’ …
Yesterday I attended my second meeting of the local writers’ group in town. I wrote something for the meeting, as well as a shorter piece during the evening (they call it a “prompt” where everyone writes for ten minutes from the same prompt, or opening line). Both of these pieces are available on my OriginalContinue reading New stuff
On 20 February 2012, just over a month from now, my blog will turn ten years old. This site, such as it is, won’t be as old, but I’ll have had a website for 16-and-a-half years. Last year I began writing a very long piece about how I’d been online for fifteen years and whatContinue reading Ten years on
(Via Yolande) 1. The fattest knight at King Arthur’s round table was Sir Cumference. He acquired his size from eating too much pi. 2. I thought I saw an eye doctor on an Alaskan island, but it turned out to be an optical Aleutian. 3. She was only a whiskey maker, but he loved herContinue reading Puns for Educated Minds
Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. His blog has a walkthrough in SQL Server Management Studio if you prefer the GUI. [Note: If you copy and paste this code, please be sure to check the quotation marks. WordPress may changeContinue reading Increasing SQL Server Error Logs
Happy new year.
Good news, all three of you that follow this blog and are interested in my ShutOff application: it’s almost done! Luckily it hasn’t taken me over twelve years to get to this point! Last week I realised that twelve years brings with it a new era: the death of anything before Windows XP, and theContinue reading ShutOff 2000 Update