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

Content with tag Performance Rss

<< Newer    Items 21 to 40 of 53    Older >>
 

Cardinality Regression

By Steve Jones 2014/06/02 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,330 reads

Cursor-Killing: Retrieving Recently Modified Data

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.  Read more...
By Edward Pollack 2014/06/02 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 6,330 reads

Upgrading cardinality

By Steve Jones 2014/05/15 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,385 reads

Hash Match

By Steve Jones 2014/05/01 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,578 reads

Divide and Conquer - Performance Tuning

Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance  Read more...
By Claire Mora 2014/04/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,785 reads

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 2014/03/24 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,950 reads

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2014/03/04 | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 8,555 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 plan
Rating: |  Discuss |   Briefcase | 23,292 reads

Performance Tuning Through Panic

We've all been there, trying to improve performance in a panic situation and not making things better.  Read more...
By Steve Jones 2014/02/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 330 reads

The Performance of the T-SQL Window Functions

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there is less SQL on the page, it is easy to assume that the performance is better too: but is it? Dwain gets out the test harness to investigate.  Read more...
By Additional Articles 2014/02/06 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,355 reads

SQL Server Health and History Tool

By Amit Raut 2014/01/29 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,592 reads

TEMPDB Configuration per vCPU

A simple script for automation of additional secondary data files of tempdb.  Read more...
By Paulo Nascimento 2014/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,080 reads

The Art of Performance

Tuning a SQL Server instance and improving the way it performs is a complex task that many people struggle to complete. In this piece, Steve Jones talks about the idea that it is a science as much as an art.  Read more...
By Steve Jones 2014/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 311 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Redgate | Category: tips
Rating:  Rate this |   Briefcase | 16,033 reads

Reporting Services Performance and Optimization

This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.  Read more...
By Additional Articles 2013/12/24 | Source: SQLCAT | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,703 reads

Index Help Utility

By Steve Jones 2013/12/11 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,775 reads

A few reflections on RBAR by a weary application developer

Follow the guidance of your DBA, but remember, he or she is from another land.  Read more...
By George Copeland 2013/12/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,834 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Redgate | Category: tips
Rating:  Rate this |   Briefcase | 16,033 reads

Improving SSIS Update Performance

This article includes an examination of how I improved update performance. We examine four methods of loading data into a data warehouse.  Read more...
Rating: |  Discuss |   Briefcase | 6,219 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 | 31,793 reads
<< Newer    Items 21 to 40 of 53    Older >>
 
Tags
t-sql (10)    
blogs (8)    
indexing (5)    
tuning (5)    
administration (4)    
editorial (3)    
execution plan (3)    
execution plans (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)    
best practices (1)    
binary flags (1)    
bit operations (1)    
bottle necks (1)    
conditional split (1)    
cpu usage data (1)    
cursors (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
debug (1)    
deleted (1)    
duplicates (1)    
effective dates (1)    
estimated plan (1)    
i/o performance (1)    
identity property (1)    
in-line memory (1)    
inserted (1)    
integration services (ssis) (1)    
jobs (1)    
lag (1)    
lead (1)    
lookup table (1)    
microsoft sql server (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query optimization (1)    
rcte (1)    
reporting services (ssrs) (1)    
schedule (1)    
scope_identity (1)    
set-based loop (1)    
software development (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sqlagent (1)    
sqlh2 (1)    
sqlio (1)    
sqlpass (1)    
sqlprep (1)    
tally table (1)    
tips (1)    
tools (1)    
trace flag (1)    
update (1)