Posts Tagged ‘Table Scan’

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 […]

Better Tag Cloud