Archive for the ‘SQL 2008 R2’ Category

Maximizing SQL Server 2008 R2 Table scan speed from DSI Solid State Storage (2010-1-2)

Scenario: Imagine you have a single table with 400 Million rows and 46 GByte in size that you want to read as fast as possible. How can you check if you run @ top speed? This blog post is all about squeezing the maximum out of both SQL Server and the available hardware and showing […]

SQL Server Day 2009 Optimization Session (2009-12-15)

My SQL and SSIS optimization session is available online as a TechNet Chopstick session:  http://www.microsoft.com/belux/TechNet/nl/chopsticks/default.aspx?id=1498