Query Optimization

The Query Optimizer: Date Correlation Optimisation

  • Article

In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?

2009-10-26

3,485 reads

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

  • Article

Microsoft SQL Server 2008 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes what data is collected, where it is stored, and which commands create, update, and delete statistics. By default, SQL Server 2008 also creates and updates statistics automatically, when such an operation is considered to be useful. This paper also outlines how these defaults can be changed on different levels (column, table, and database).

2009-07-24

2,506 reads

Blogs

A Memory-Optimized Roundup – T-SQL Tuesday #117

By

The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...

How do you debug your spark-dotnet app in visual studio?

By

When you run an application using spark-dotnet, to launch the application you need to...

More PowerShell Remoting coverage in dbatools

By

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...

Read the latest Blogs

Forums

Reading Part of a Dataframe

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reading Part of a Dataframe

The First Rule

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The First Rule

ColumnStore Indexes not releasing the Deleted Rows

By TRACEY-320982

In on table which has CCI columnstore indexes on it, and I run select...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers