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

Content with tag Execution Plans Rss

   Items 1 to 20 of 83    Older >>
 

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 78,559 reads

Post-Deployment - Scan for RefreshView/Recompile

A script I can run after deployment to refresh views and force a recompile due to modified DDL.  Read more...
By Nate Hughes 2016/03/18 | Source: SQLServerCentral.com | Category: deployment
Rating: (not yet rated) |  Discuss |   Briefcase | 395 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 78,559 reads

JOIN HINTS

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

Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

Learn how to examine and read a SQL Server execution plan in this article. This is the third part of a short series from Darren White that examines execution plans and imparts the basics on an important skill for DBA's and SQL developers alike.  Read more...
By Darren White 2016/01/08 (first published: 2014/02/25) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 17,903 reads

Actual “Number of Rows Read” in SQL Server Execution Plans

Kendra Little takes a look at the upcoming SQL Server 2016 'Number of Rows Read' feature in action.  Read more...
By Additional Articles 2015/12/31 | Source: Other | Category: number of rows read
Rating: (not yet rated)  Rate this |   Briefcase | 3,970 reads

Big plans

By Hugo Kornelis 2015/12/14 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,393 reads

Join operators, part 3 - performance

By Hugo Kornelis 2015/12/07 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,298 reads

Join operators, part 2 - limitations

By Hugo Kornelis 2015/11/30 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,234 reads

Join operators, part 1 - terminology

By Hugo Kornelis 2015/11/19 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,516 reads

Pass Through

By Hugo Kornelis 2015/11/13 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,296 reads

Capture Execution Plan Warnings using Extended Events

Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.  Read more...
By Additional Articles 2015/11/13 | Source: SQLPerformance.com | Category: extended events
Rating: (not yet rated)  Rate this |   Briefcase | 2,192 reads

Index Scan: Ordered or not?

By Hugo Kornelis 2015/11/09 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,510 reads

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2015/10/09 (first published: 2013/08/12) | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 14,020 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 78,559 reads

Operator Description

By Junior Galvão - MVP 2015/05/28 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,477 reads

Constant Scan Operator

By Junior Galvão - MVP 2015/05/13 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,390 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 78,559 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 78,559 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 | 26,382 reads
   Items 1 to 20 of 83    Older >>
 
Tags
t-sql (9)    
performance tuning (7)    
performance (6)    
blogs (5)    
books (4)    
indexing (4)    
performance and tuning (4)    
query optimizer (4)    
actual plan (2)    
estimated plan (2)    
hash match (2)    
merge join (2)    
operators (2)    
tuning (2)    
administration (1)    
best practices (1)    
book reviews (1)    
clustered index (1)    
covering index (1)    
covering indexes (1)    
creating graphical execution plan (1)    
cursors (1)    
dbcc dropcleanbuffers (1)    
dbcc freeproccache (1)    
deployment (1)    
editorial (1)    
extended events (1)    
hash (1)    
high performance sql server series (1)    
index seek (1)    
indexed views (1)    
in-memory oltp (1)    
loop (1)    
merge (1)    
nested loop (1)    
nhibernate (1)    
non clustered indexes (1)    
number of rows read (1)    
online re-indexing (1)    
parallelism (1)    
parameter sniffing (1)    
partition table (1)    
plan cache (1)    
primary key (pk) (1)    
query optimization (1)    
query plan (1)    
query plans (1)    
reading execution plan (1)    
rebind and rewinds (1)    
sort operator (1)    
sp_prepexec (1)    
sql server 2012 (1)    
sql server 2016 (1)    
statistics (1)    
stored procedures (1)    
table spool operator (1)    
t-sql tuesday (1)    
update statistics (1)