September 2012

Reorganizing transaction tables for faster historical queries

Sometimes we have a transaction table that is frequently queried for historical data, but the query, while well-tuned, is too slow simply because it has to do a sequential read on an index and then retreive the table’s row over and over. For a query that retrieves many rows, it can run slower than needed […]

Read more →

Understanding SQL Server Snapshot Transaction Isolation Level

By Nick Geiger In search of a firmer understanding of how SQL Server 2008 treats transactions with the snapshot transaction isolation level (we’re thinking of using it to reduce locking issues), we tried some experiments. To perform the experiments, I created a database and a table with the following scripts. create database SnapshotDB; use SnapshotDB; […]

Read more →