Nolock and your financial application
The NOLOCK indexing hint gets used way, way to frequently. The place that I hate seeing it the most is in financial applications, where I see it way to often. Developers who are working on financial applications need to understand just how important not using NOLOCK is. Using NOLOCK isn’t just a go faster button, […]
Preventing Locking, Blocking and Deadlocks in the vCenter database
As our VMware environments become larger and larger with more and more hosts and guests more thought needs to be given to the vCenter database that is typically running within a SQL Server database. With the vCenter database running within Microsoft SQL Server (which is the default) their will be lots of locking and blocking […]
Recommended reading from mrdenny for July 05, 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. Bootstrapping SQL Server bloggers and blog readers with Twitter! Whiteboard Wednesday #1: Top Visualization Mistakes The Accidental Architect Personally Identifiable Information (PII) and Data Encryption Traversing the Facebook Graph using Data Explorer […]
Backups & the Buffer Pool
As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine. So what happens to the buffer pool when backups are taken? The answer is that nothing happens to the buffer pool. When SQL Server is backing up data from the disk, […]