Recommended reading from mrdenny for May 24, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. EXECUTE, not required, but advisable. Windows Azure SQL Database and SQL Server — Performance and Scalability Compared and Contrasted Setting up Quorum Node Weight in a Windows Server Failover Cluster Central Subscriber […]
The Optimizer Isn’t As Smart As You Might Want It To Be
A little while back I got one of those phone calls. You know the one, the lovely 6am phone call about random performance problems. There were two problems that night. One which I’ll talk about later in another post, the second one which I want to talk about today. The query that was having problems […]
Recommended reading from mrdenny for May 17, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Common Table Expressions (CTEs), Window Functions, and Views How big of a risk is BYOD? How can I get that user out of my table quickly Unemployed Chinese Graduates Say No Thanks […]
Error Handeling and DBCC CHECKDB
A client that I’ve been working at for a while needed to start doing DBCC CHECKDBs on their production server. We hadn’t been for a little while due to maintenance window constraints on their old production server. Now that we’ve scaled the application across 6 different servers we can now do DBCC CHECKDB on the […]