Monthly Archives: July 2011

Current Database Update All Table Statistics with Fullscan

Validated against: SQL Server 2005. Updating statistics against each table in the current database by using the undocumented stored procedure [sp_MSforeachtable].

Posted in SQL 2005, SQL 2008, SQL 2008 R2 | Tagged | Comments Off on Current Database Update All Table Statistics with Fullscan

Efficient Numbers Table

Validated against: SQL Server 2005. Just performed a quick Google of the various methods of acquiring a list of sequential numbers and recommend the approach by Itzik Ben-Gan. The approach uses a small footprint of code and allows numbers up … Continue reading

Posted in SQL 2005, SQL 2008, SQL 2008 R2 | Tagged | Comments Off on Efficient Numbers Table

Disk Subsystem Benchmarking

When benchmarking disk subsystems, I generally benchmark against the most challenging task; which is random writes, with no buffering! The tool I use is the Microsoft SQLIO tool that measures IO performance. The SQLIO tool can be acquired from: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20163 … Continue reading

Posted in SQL 2005, SQL 2008, SQL 2008 R2 | Tagged | Comments Off on Disk Subsystem Benchmarking