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

Content with tag Performance Rss

   Items 1 to 20 of 65    Older >>
 

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2016/04/22 (first published: 2014/03/24) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 12,429 reads

Performance Surprises and Assumptions: STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. In this article, Aaron Bertrand compares its performance to existing methods.  Read more...
By Additional Articles 2016/04/06 | Source: SQLPerformance.com | Category: string_split
Rating:  Rate this |   Briefcase | 3,546 reads

Sparse Columns in SQL Server : Impact on Time & Space

Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.  Read more...
By Additional Articles 2016/03/15 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,168 reads

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 3,159 reads

Query Performance Report

The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.  Read more...
By Steven Guest 2016/01/20 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,694 reads

Combining R and SQL Server to diagnose performance bottlenecks

Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.  Read more...
By Nick Burns 2015/12/07 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 7,818 reads

proc to calculate DM_OS_PERFORMANCE_COUNTERS over time interval

This is a stored proc that gives you the calculated performance counters over a time interval you specify.  Read more...
By John Heimiller 2015/12/04 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 892 reads

Data Mining Part 33: The Performance counters

In this new article, we will explain how to use the Performance Counter to measure performance and activity in Microsoft Data Mining  Read more...
By Daniel Calbimonte 2015/11/26 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,413 reads

What's changed recently?

Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...  Read more...
By Ian Stirk 2015/10/20 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 3,741 reads

CXPACKET

By Steve Jones 2015/09/21 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,577 reads

SQL Server CPU Usage History Histogram

Returns a summary of CPU usage by SQL Server over the last 4 hours (default). Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.  Read more...
By Jonathan Allen 2015/09/18 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,124 reads

Find Most Expensive Stored Procedure (By Execution Count)

SQL Server Stored Procedure Execute Count Script ..   Read more...
By Yusuf Kahveci 2015/09/08 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,887 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2015/07/27 | Source: SQLServerCentral.com | Category: set-based loop
Rating: |  Discuss |   Briefcase | 13,669 reads

Analyzing I/O Performance for SQL Server

Inadequate storage is one of the most common bottlenecks seen in subsystem performance. There are a number of reasons for poor storage performance, but measuring it and understanding what needs to be measured and monitored is always a useful exercise.   Read more...
By Additional Articles 2015/07/21 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,753 reads

Query Performance Report

The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.  Read more...
By Steven Guest 2016/01/20 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,694 reads

Testing SQL Server Backup Performance with Trace Flag 3042

Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.  Read more...
By Additional Articles 2015/05/19 | Source: MSSQLTips.com | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 6,178 reads

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,220 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,372 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2015/02/06 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 33,711 reads

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...
By Grant Fritchey 2015/01/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,782 reads
   Items 1 to 20 of 65    Older >>
 
Tags
t-sql (10)    
blogs (8)    
execution plans (6)    
indexing (6)    
administration (5)    
tuning (5)    
editorial (3)    
sql server 2014 (3)    
cardinality estimates (2)    
hash match (2)    
merge (2)    
optimization (2)    
query optimizer (2)    
sql trace (2)    
statistics (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
agent jobs (1)    
best practices (1)    
binary flags (1)    
binding (1)    
bit operations (1)    
bottle necks (1)    
conditional split (1)    
counters (1)    
cpu usage data (1)    
cursors (1)    
cxpacket (1)    
data mining (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
debug (1)    
deleted (1)    
dm_os_performance_counters (1)    
duplicates (1)    
effective dates (1)    
estimated plan (1)    
foreign keys (1)    
i/o performance (1)    
identity property (1)    
in-line memory (1)    
inserted (1)    
integration services (ssis) (1)    
lag (1)    
lead (1)    
lookup table (1)    
machine learning (1)    
microsoft sql server (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query optimization (1)    
r programming (1)    
rcte (1)    
referential integrity (1)    
reporting services (ssrs) (1)    
schedule (1)    
scope_identity (1)    
set-based loop (1)    
software development (1)    
sparse columns (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sql server dmvs (1)    
sqlagent (1)    
sqlh2 (1)    
sqlio (1)    
sqlpass (1)    
sqlprep (1)    
string_split (1)    
tally table (1)    
tips (1)    
tools (1)    
trace flag (1)    
update (1)