Improve Your Missing Index Recommendations

Always Listen to Advice; Don’t Always Follow It We have on many occasions looked at query execution plans in the Management Studio. No doubt you have noticed that occasionally a green note appears in the heading of the plan describing a “missing index”. What could be better? SQL Server is telling you what indexes you […]
Read More ›

Using Covering Indexes to Avoid Hashes and Sorts

In the previous installment, we saw that covering indexes can reduce the number of page reads required to satisfy specific queries, thereby improving performance for those queries. We’ll turn our attention now to some more subtle applications of covering indexes. For this, we will use the ContosoRetailDW sample database, which is considerably larger than the […]
Read More ›

Explore the Benefits of Covering Indexes

Sometimes the old ways are still the best- even in technology. Long before there was an SQL Server, database professionals made advantageous use of the “covering” index, so-called because the columns used in the index cover all the requirements of a particular query of special interest. Let’s take a look at a class covering indexes […]
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 ›

How Much do SQL Server Data Professionals Make?

You’ve thought about your career, you can’t make up your mind about which direction you want to take it. You want to make an informed decision and work out if the career you chose will provide you with financial security you need. The good people at brentozar.com have been running a salary survey and the […]
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.