How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups

Trace Flags

Getting the Most out of Statistics

Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!

Temporary Tables and Statistics in Stored Procedures

Generated script to update statistics

Generated script to update statistics

Updating Statistics

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.

Reduce Time for SQL Server Index Rebuilds and Update Statistics

This tip will explore two features to speed up SQL Server index and statistics maintenance in the SQL Server Enterprise, Standard and Express editions.

Auto Create Statistics

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.