Archive for August, 2011
This will make a great blog post someday…
Ever have one of those days when you feel like you know absolutely nothing? That pretty much sums up the past week for me. I’ve been fighting with a performance problem and have come up empty on all fronts. WTF? We’re in the middle of a project to upgrade one of our financial databases. The [...]
August 29, 2011
Tags: execsync, performance, waits Posted in: Troubleshooting 
5 Comments
SQL Server A to Z – Locks
Time once again for another installment of SQL Server A to Z. Today we’re talking about locks. Locking is just a fact of life with any RDBMS, it’s what allows you to have multiple concurrent users in your database while still maintaining data integrity. Without locks there would be chaos. Chaos I tell you. So [...]
August 25, 2011
Tags: a to z, locks Posted in: General No Comments
Index Maintenance: Rebuild vs Reorg
A developer asked me today what the difference was between ALTER INDEX … REBUILD and ALTER INDEX … REORGANIZE. One of the scripts he was running was first doing a rebuild of all indexes on a table, then doing a reorg, and he wanted to know if the reorg was necessary. I took his question [...]
August 22, 2011
Tags: index maintenance Posted in: Maintenance 2 Comments
SQL Server A to Z – Kerberos
Some letters get all the love. Take ‘C’ for example. You’ve got collation, clustering, compression, constraints, change data capture… Colleen. And what about ‘A’? Atomnicity, authentication, automation, auditing, Azure, and so on. But not ‘K’. What does poor little ‘K’ get? Kill? Keywords? Meh. So today I’m talking about Kerberos. I’ll tell you a little [...]
August 18, 2011
Tags: a to z, kerberos, security Posted in: General, Security 2 Comments
Applied SQL – You’ve got homework
Jen McCown (blog | twitter) is giving us homework. When I was a kid I didn’t like homework. It was always so boring. Well, except for the time I had to do a diorama on dinosaurs. Now that was fun. Kids don’t do dioramas anymore do they? Pity. Anywho, Jen has started a series on [...]
August 17, 2011
Tags: AppliedSQL, tsql Posted in: T-SQL One Comment
