July 2010 - Posts

• Taming the Log-Eating Defrag Beast

  SQL Server Standard Edition can be a beautiful thing. Since failover clustering, 64-bit support and the corresponding big memory became available with Standard Edition in 2005, it can handle most SQL workloads demanded by a small or medium business. Unless Read More... Posted Tuesday, July 27, 2010 3:20 PM by merrillaldrich | 9 Comments

• A Schema Riddle

  Here’s a puzzle I had to untangle this week. When would a SQL Server sysadmin login not find an existing object in a database, while a plain-vanilla user can? A colleague came to me the other day with an interesting scenario he could not figure out. He Read More... Posted Wednesday, July 14, 2010 11:47 PM by merrillaldrich | 1 Comments

• Last One to DB Mirroring’s a Rotten Egg

  This week was a bit of a milestone for me in my current job. We took delivery of six shiny new Nehalem-based HP DL380’s. These are very nice little servers (not so little anymore, truth be told, if you look at the workload they can handle) but that’s Read More... Posted Friday, July 09, 2010 9:24 PM by merrillaldrich | 5 Comments