Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Query Optimizer Rss

   Items 1 to 11 of 11   
 

JOIN HINTS

By Uwe Ricken 2016/01/14 | Category: query optimization
Rating: (not yet rated) |  Discuss |   Briefcase | 1,514 reads

How to Confuse the SQL Server Query Optimizer

Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.  Read more...
By Additional Articles 2015/09/21 | Source: SimpleTalk | Category: query optimizer
Rating:  Rate this |   Briefcase | 3,248 reads

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.  Read more...
By Darren White 2015/02/13 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 25,955 reads

Importance of Statistics and How It Works in SQL Server – Part 1

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.  Read more...
By Additional Articles 2015/01/07 | Source: Database Journal | Category: query optimizer
Rating:  Rate this |   Briefcase | 7,689 reads

Problems with partitioned views

By Uwe Ricken 2015/01/06 | Category: partitioned views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,126 reads

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!  Read more...
By Edward Pollack 2014/06/09 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 5,221 reads

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.  Read more...
By Darren White 2015/02/13 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 25,955 reads

Variable Declaration

By Paul Cauchon 2013/09/19 | Category: query optimizer
Rating: (not yet rated) |  Discuss |   Briefcase | 2,785 reads

Understanding SQL Server Query Optimization Statistics

In this article, you will learn what query optimisation statistics are and how SQL Server query optimizer uses statistics. You will also learn how to create and manage statistics, and what are the different ways to determine when statistics were last updated in SQL Server.  Read more...
By Additional Articles 2013/07/10 | Source: SQL Server Performance | Category: query optimizer
Rating: (not yet rated)  Rate this |   Briefcase | 4,145 reads

Statistics on Ascending Columns

It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano Amorim once again dons snorkel and goggles to explore the murky depths of execution plans to find out why.  Read more...
By Additional Articles 2011/09/16 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 2,260 reads

The SQL Server Query Optimizer

To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.  Read more...
By Additional Articles 2011/09/09 | Source: SimpleTalk | Category: query optimizer
Rating:  Rate this |   Briefcase | 4,592 reads
   Items 1 to 11 of 11   
 
Tags
execution plans (4)    
performance (2)    
statistics (2)    
actual plan (1)    
ascending columns (1)    
best practices (1)    
contradiction (1)    
estimated plan (1)    
hash (1)    
loop (1)    
merge (1)    
partitioned views (1)    
query optimization (1)    
sql server (1)    
t-sql (1)    
union (1)