Posts Tagged ‘SQL’

SQL under the hood (Part 2): Estimate the SQL Disk IO Workload based on the Virtual File Stats DMV. (2012-1-20)

Category: SQL 2008 R2, Workload & Capacity Planning | Tags: , , , | 2 Comments

Do you know how much data is being written and read on a daily basis by your SQL Server databases? SQL Server keeps track of these stats for you already; you just have to retrieve and interpret them correctly so you can turn this data into valuable information. A couple of years ago I was […]

Optimizing SQL In Memory Table Scan processing speed (2010-1-9)

Category: SQL 2008 R2 | Tags: , , , , | 4 Comments

How fast can you can actually read data from a table that is already loaded in memory?  People often assume that, once it’s in memory, it’s as fast as it can get and won’t get any faster ? But how fast is it really ?  Let’s find out! The Math Method If the total table […]

Better Tag Cloud