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 75    Older >>
 

5 Advantages of Load Balancing For IT Companies

As an IT company, it is crucial that you maintain uptime and monitor the performance of various processes. By making database load balancing a key element, you can ensure that your processes and websites run smoothly. Tony Branson explains.  Read more...
By Additional Articles 2016/11/24 | Source: Database Journal | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,193 reads

What's Your Backup Speed?

This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.  Read more...
By Steve Jones 2016/11/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

Server Hardware or Coffee?

Today Steve Jones looks at the relative cost of hardware and how we sometimes cause ourselves issues by not spending enough.  Read more...
By Steve Jones 2016/11/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 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 2016/10/07 (first published: 2015/07/27) | Source: SQLServerCentral.com | Category: set-based loop
Rating: |  Discuss |   Briefcase | 17,726 reads

Report overlapping jobs

This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.  Read more...
By Wilfred van Dijk 2016/07/29 | Source: SQLServerCentral.com | Category: sqlagent
Rating: |  Discuss |   Briefcase | 1,943 reads

Finding and Eliminating Duplicate or Overlapping Indexes

Duplicate & Overlapping Indexes can be a drag on write speed and disk resources. How do we find and eliminate them quickly and effectively?  Read more...
By Edward Pollack 2016/07/08 (first published: 2014/06/16) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 11,538 reads

A Comparison of JDBC Drivers for MySQL

A brief comparison of three different JDBC Drivers built for connecting with MySQL  Read more...
By Jerod Johnson 2016/05/19 | Source: SQLServerCentral.com | Category: jdbc
Rating: |  Discuss |   Briefcase | 824 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 2016/05/13 (first published: 2014/03/04) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 13,153 reads

Performance Surprises and Assumptions : DATEADD()

Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.  Read more...
By Additional Articles 2016/05/12 | Source: SQLPerformance.com | Category: dateadd
Rating: (not yet rated)  Rate this |   Briefcase | 4,408 reads

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Ability to enable Instant File Initialization during the installation of SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 1,139 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 2016/04/22 (first published: 2014/03/24) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 13,262 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,730 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,306 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 (fk)
Rating: |  Discuss |   Briefcase | 3,273 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,852 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,888 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 | 924 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,436 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,755 reads

CXPACKET

By Steve Jones 2015/09/21 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,603 reads
   Items 1 to 20 of 75    Older >>
 
Tags
t-sql (10)    
blogs (8)    
execution plans (6)    
indexing (6)    
administration (5)    
editorial (5)    
tuning (5)    
sql server 2014 (3)    
cardinality estimates (2)    
comparison (2)    
hash match (2)    
merge (2)    
optimization (2)    
query optimizer (2)    
sql trace (2)    
statistics (data) (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
agent jobs (1)    
backup (1)    
best practices (1)    
binary flags (1)    
binding (1)    
bit operations (1)    
bottle necks (1)    
conditional split (1)    
consolidation (1)    
counter (1)    
cpu usage data (1)    
cursors (1)    
cxpacket (1)    
data mining (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
dateadd (1)    
debug (1)    
deleted (1)    
dm_os_performance_counters (1)    
duplicates (1)    
effective dates (1)    
estimated plan (1)    
foreign keys (fk) (1)    
friday poll (1)    
hardware (1)    
i/o performance (1)    
identity property (1)    
in-line memory (1)    
inserted (1)    
instant file initialization (ifi) (1)    
integration services (ssis) (1)    
jdbc (1)    
lag (1)    
lead (1)    
load balancing (1)    
lookup table (1)    
machine learning (1)    
microsoft sql server (1)    
migration (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query (1)    
query optimization (1)    
r language (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 2016 (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)    
upgrade (1)