I’ll be attending SQL Saturday #47 – Phoenix this Saturday, Feb 19! It’s being held just a few minutes from my house, so I really couldn’t pass it up! This will be my first SQL Saturday event and I am looking forward to it. If you see me, say hi. (I tend to be pretty […]
I had to play detective a bit this week. I get a weekly report that gives me a list of databases that have more than 50 VLFs in their transaction log files. I posted the code that generates it here. My transaction logs are in pretty good shape now and I only occasionally get a […]
Last week I wrote about some bad programming I discovered in Solarwind’s Orion monitoring software. One of their maintenance utilities reindexed the tables in the database, then performed a database shrink. This immediately creates about 100% index fragmentation. I don’t mean to pick on Orion, but I have been doing some more digging and discovered […]
This post contains details about the behavior of one particular program we use here at my work, but the general idea should be applicable anywhere. The IT department at my work, of which I am a part, uses a tool called Orion by Solarwinds Software for network performance monitoring. The software uses SQL Server as […]
A commenter recently reminded me that, although I had mentioned that I attempted to do a migration from SQL 2000 to 2008 a while back, failed, and had to go back to the old version, I never really explained what happened. So now I will! We had a SQL Server cluster running SQL 2000. One […]