SQLServerCentral: Content tagged Blogs, Performance Tuning

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 | 1,925 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,406 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 | 1,474 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 | 986 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 | 3,720 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,001 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,224 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,625 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,935 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,003 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 | 2,995 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 | 1,961 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 | 4,854 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,001 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,174 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,204 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,018 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 | 2,882 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,171 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,804 reads

Content with tags Blogs, Performance Tuning