More in Database Performance Tuning

  • computer keyboard with blue tool key
    Sep 18, 2012

    Don't Forget about Backup Compression

    I recently ‘inherited’ a couple of SQL Servers for a client – running SQL Server 2008 (Enterprise Edition). In the process of ‘taking over’ these boxes I’ve scrutinized a number of jobs and details – including backups....More
  • performance check list
    Sep 13, 2012

    Performance Tip: Find Your Most Expensive Queries

    One thing I’m asked on a regular basis when working with SQL Server Consulting clients that don’t have much experience with performance tuning, is how to find what their most expensive queries are. Only, the problem is that the answer to that question can be a bit more complex than you might think....More
  • Jul 25, 2012

    DBAs and Windows Event Logs

    While watching a military documentary with my son the other night, I was struck by just how crazy it is that snipers need to account for wind. I mean, yeah: I get it – they’re shooting at targets that are ridiculously far away and I’ve known for a long time that they have to account for wind....More
  • Geese running
    Jun 27, 2012

    Filtering out benign waits

    The simple answer is that not all waits need to be analyzed when doing performance troubleshooting....More
  • multicolored ethernet network cables
    Jun 20, 2012

    Altering execution priority using Resource Governor

    Most people know that Resource Governor allows you to specify CPU and memory limits when contention for these resources occurs, but it’s a little-known fact that you can configure relative priorities as well....More
  • blue computer keyboard Delete key
    Jun 14, 2012

    How record DELETEs can cause index fragmentation 2

    Record deletion can indeed cause fragmentation. There are two kinds of fragmentation described by SQL Server Books Online: logical fragmentation and low page density....More
  • May 31, 2012

    SQL Server Database Corruption, Part XII: Recovery Sample 2

    In my last post in this ongoing series on SQL Server database corruption I mentioned that my next post would be to provide a ‘soup to nuts’ sample or example of how you can test corruption and recovery in your own environment – as a means of better getting familiar with exactly what corruption is, what it looks like, and how to address it....More
  • May 16, 2012

    Curious Case of the missing SOS_SCHEDULER_YIELD waits 1

    Many of the monitoring scripts/tools for looking at wait statistics aggregate all the wait statistics and return the top 95% of all waits occurring, sorted by most prevalent waits by total wait time....More
  • Apr 17, 2012

    How to prevent table scans when searching LOB data? 2

    If a SELECT has the LOB column in the WHERE clause then the query plan will involve a table scan – as you cannot create a nonclustered index over a LOB column....More
  • Apr 3, 2012

    What about moving LOB data while keeping the table online?

    Moving LOB data associated with a table isn't simple—even with the SQL Server 2012 ability to rebuild indexes that include LOB data as an online operation. The key reason is the behavior of LOB data during these operations....More
  • illustration of data cube with red arrows indicating movement
    Mar 21, 2012

    What about moving LOB data? 2

    There are actually a couple of ways to move LOB data associated with a table. Let's tackle moving LOB data using OFFLINE operations....More
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Save money red computer keyboard key
Jul 30, 2014

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....More
Health check note on computer keyboard
Jul 28, 2014

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×