SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Execution Plans Rss

   Items 1 to 20 of 107    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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 reads

Execution Plans and Data Protection

One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.  Read more...
By Additional Articles 2018/04/30 | Source: SimpleTalk | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,260 reads

How to Show the Execution Plan of a Running Query

By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?  Read more...
By Additional Articles 2018/04/20 | Source: Database Journal | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 4,024 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 reads

Why sp_prepare Isn’t as “Good” as sp_executesql for Performance

Erik Darling shows how execution plan estimates suffer.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,197 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 reads

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2018/01/05 (first published: 2016/06/07) | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 5,189 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 reads

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.  Read more...
By Additional Articles 2017/06/20 | Source: SQLPerformance.com | Category: trace flags
Rating: (not yet rated)  Rate this |   Briefcase | 4,668 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 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 2017/03/10 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 29,838 reads

Office Hours Webcast 2017/02/01

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.  Read more...
By Additional Articles 2017/02/14 | Source: Brent Ozar Unlimited Blog | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 3,591 reads

Determining What Happens When You Force an Execution Plan via the Query Store

When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.  Read more...
By Additional Articles 2017/02/07 | Source: SimpleTalk | Category: query store
Rating:  Rate this |   Briefcase | 3,394 reads

Comparing Execution Plans

By Grant Fritchey 2016/12/14 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 1,139 reads

Retrieving SQL Server Query Execution Plans

Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.  Read more...
By Additional Articles 2016/12/14 | Source: SimpleTalk | Category: execution plans
Rating:  Rate this |   Briefcase | 3,818 reads

Troubleshooting a painful query using execution plans in SQL Monitor

When something's wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem fast. Grant Fritchey explains how you can use execution plans inside SQL Monitor to help quickly and simply identify the problem.  Read more...
By Additional Articles 2016/12/09 | Source: Redgate | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,519 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 2018/06/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 106,345 reads

Plans for long rows

By Steve Jones 2016/09/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,194 reads
   Items 1 to 20 of 107    Older >>
 
Tags
t-sql (11)    
performance (7)    
performance tuning (7)    
blogs (5)    
performance and tuning (5)    
query optimizer (5)    
books (4)    
indexing (4)    
actual plan (2)    
estimated plan (2)    
hash match (2)    
merge join (2)    
operators (2)    
query plans (2)    
sql server 2016 (2)    
tuning (2)    
administration (1)    
always on (1)    
availability group (ag) (1)    
best practices (1)    
book reviews (1)    
clustered index (1)    
computed columns (1)    
covering index (1)    
covering indexes (1)    
creating graphical execution plan (1)    
cursors (1)    
data protection (1)    
dbcc dropcleanbuffers (1)    
dbcc freeproccache (1)    
deployment (1)    
editorial (1)    
extended events (xe) (1)    
hash (1)    
high availability (ha) (1)    
high performance sql server series (1)    
index seek (1)    
indexed views (1)    
in-memory oltp (1)    
lazy spool (1)    
log shipping (1)    
loop (1)    
merge (1)    
nested loop (1)    
nhibernate (1)    
non clustered indexes (1)    
ntile (1)    
number of rows read (1)    
online re-indexing (1)    
parallelism (1)    
parameter sniffing (1)    
partition table (1)    
percent_rank (1)    
percentile rank (1)    
plan cache (1)    
primary key (pk) (1)    
query optimization (1)    
query plan (1)    
query store (1)    
rank distribution function (1)    
reading execution plan (1)    
rebind and rewinds (1)    
redgate (1)    
service packs (1)    
sort operator (1)    
sp_executesql (1)    
sp_prepexec (1)    
sql monitor (1)    
sql server 2012 (1)    
statistics (data) (1)    
stored procedures (1)    
table spool operator (1)    
trace flags (1)    
t-sql tuesday (1)    
update statistics (1)    
window functions (1)