Optimize SQL Server Queries with Index Statistics

Television’s Mythbusters seem to have a lot of fun; it’s interesting that so many myths seem to involve blowing stuff up on camera. SQL myth-busting may not be as visually dramatic, but for people who are interested in query performance, it is much more important. There are a lot of people who think that it […]
Read More ›

Optimize Your SQL Server Queries with Column Statistics

Have you ever done something that your mother told you to never ever do? Well, we’re going to do that today, except with SQL Server. We’re going to get rid of SQL Server column statistics with the goal of learning what column statistics are and how they help SQL Server arrive at superior query plans. […]
Read More ›

Exploring the SQL Server Query Optimizer

The SQL Server Query Optimizer is always of great interest to students taking Learning Tree’s Developing SQL Queries for SQL Server and Developing High-Performance SQL Server Databases courses. Today we’ll look beyond the operators in the query plan and focus our attention on some aspects of the optimization process itself. Optimization is always a balancing […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.