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

Content with tags Performance Tuning, Blogs Rss

   Items 1 to 20 of 23    Older >>
 

Implicit Conversions and Avoiding Them With Computed Columns

I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...  Read more...
By John Sansom 2013/04/02 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,642 reads

Sub query pass through

Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...  Read more...
By Dave Ballantyne 2013/03/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,751 reads

Benchmark SQL Server Disk Latency

Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...  Read more...
By jsterrett 2013/03/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,405 reads

Running SQLIO with Multiple Files

Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files?  Until a couple months...  Read more...
By StrateSQL 2013/02/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,432 reads

SQL Server : Parameter Sniffing

Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....  Read more...
By 2012/06/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,020 reads

Which SELECT * Is Better?

The short answer is, of course, none of them, but testing is the only way to be sure. I was asked,...  Read more...
By 2012/05/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,360 reads

RECONFIGURE can flush the procedure cache

I ran across this KB article the other day, which lists a few ways in which performance is affected by...  Read more...
By 2012/01/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,519 reads

On Leadership - Lead by Example

This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...  Read more...
By 2011/04/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,776 reads

Use Patterns and Prior Code and Don't Reinvent the Wheel

In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...  Read more...
By 2011/02/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,995 reads

Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2

Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...  Read more...
By GlennBerry 2011/01/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,208 reads

Do IF statements cause recompiles?

I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...  Read more...
By Gail Shaw 2010/12/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,136 reads

Successful Teams: Capable Backups

No, not backups as in SQL Server backups, but who to tag when someone is out or so slammed with...  Read more...
By 2010/11/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,134 reads

Memory

Not a sound from the pavement. Have you ever come across a SQL query that used to run faster?  Has that...  Read more...
By Jason Brimhall 2010/08/30 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 5,013 reads

Don't Throw Something New In At Production Deployment

This post comes from a conversation I had with a developer last week as well as my experiences over the...  Read more...
By 2010/03/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,139 reads

Breaking Down TempDB Contention

Breaking Down TempDB Contention  What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...  Read more...
By Robert Davis 2010/03/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,237 reads

The Right Attitude to be a Mentor

When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....  Read more...
By Brian Kelley 2010/01/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,300 reads

Taking Notes When You Don't Have a Computer

Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...  Read more...
By 2009/12/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,151 reads

Fundamentals of Storage Systems – RAID, An Introduction

In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...  Read more...
By Wesley Brown 2009/12/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,118 reads

Fundamentals of Storage Systems – Capturing IO Patterns

We often take the advice given to us on forums or in articles at face value. Even though the authors...  Read more...
By Wesley Brown 2009/11/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,392 reads

SQL Server Legend – Data Files and Threads

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...
By Steve Jones 2009/10/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,994 reads
   Items 1 to 20 of 23    Older >>
 
Tags
hardware (4)    
leadership (4)    
professional development (4)    
t-sql (4)    
architecture (2)    
fundamentals (2)    
io (2)    
sql server (2)    
storage (2)    
tools (2)    
.net (1)    
availability (1)    
execution plans (1)    
hard disk (1)    
host bus adapter (1)    
i/o (1)    
off-topic (1)    
procedure cache (1)    
query performance (1)    
raid (1)    
sas (1)    
sata (1)    
sql server 2005 (1)    
storage management (1)    
training (1)