Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Query Optimization Rss

   Items 1 to 9 of 9   

Query Stats

DBAs rarely use the full potential of sys.dm_exec_query_stats.  It’s common to see the queries for looking at the most expensive...  Read more...
By SteveHood79 2013/09/04 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,856 reads

Let the optimizer drive

For many, there is something disconcerting in the idea of the Query Optimizer; they crave control, but it really is best to take a back seat and let the Optimizer do its job.  Read more...
By Tony Davis 2011/02/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 173 reads

Searching for Plans

Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.  Read more...
By Steve Jones 2010/09/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 144 reads

13 Things You Should Know About Statistics and the Query Optimizer

Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a mention of Brazilian Soccer stars and young ladies on Copacabana beach. You'll never quite think of statistics, execution plans, and the query optimiser the same way again after reading this, but we think you'll understand them better.  Read more...
By Additional Articles 2010/02/02 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 5,476 reads

Query Optimizer and Cartesian Products

In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano Amorim takes a moment to point out a potential pitfall you may encounter. A light read, but one worth persuing.  Read more...
By Additional Articles 2010/01/01 | Source: SimpleTalk | Category: query optimization
Rating:  Rate this |   Briefcase | 3,132 reads

The Query Optimizer: Date Correlation Optimisation

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?  Read more...
By Additional Articles 2009/10/26 | Source: SimpleTalk | Category: query optimization
Rating:  Rate this |   Briefcase | 3,209 reads

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

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).  Read more...
By Additional Articles 2009/07/24 | Source: TechNet Blogs | Category: query optimization
Rating: (not yet rated)  Rate this |   Briefcase | 2,122 reads

Comparing Stored Procedures, Part 5

Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures   Read more...
By Jesse McLain 2009/04/03 | Source: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,116 reads


By bitbucket-25253 2008/06/25 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 4,132 reads
   Items 1 to 9 of 9   
editorial (2)    
statistics (2)    
administration (1)    
blogs (1)    
database weekly (1)    
performance (1)    
performance testing (1)    
performance tuning (1)    
sql server 2008 (1)    
string comparison (1)    
text matching (1)    
t-sql (1)