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 […]
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 […]
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 […]
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 […]
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 […]
