Tag Archives: Performance Tuning

Book Review–Database Benchmarking

Database Benchmarking by Mike Ault, Kevin Kline, Dr. Bert Scalzo, Claudia Fernandez, Donald K. Burleson Overview I will give this book one thing, it was relatively easy to read.  I finished it in just a few days while working on … Continue reading

Posted in Books | Tagged , | Leave a comment

Performance Tuning with SQL Server Dynamic Management Views

Performance Tuning with SQL Server Dynamic Management Views By Louis Davidson and Tim Ford I’m not 100% certain what it was that I was expecting from this book.  From one review I had read on amazon, I was halfway expecting … Continue reading

Posted in Books | Tagged , , , , | Leave a comment

Microsoft SQL Server 2008 Internals

Microsoft SQL Server 2008 Internals by Kalen Delaney et al. Microsoft SQL Server 2008 Internals took me a good six weeks to finish as it had so much information to consume that I would often find myself reading for ten … Continue reading

Posted in Books | Tagged , , , , , | 2 Comments

70-451–MCITP–Designing a Database for Optimal Performance–Resolve Performance Problems by Using Plan Guides

Requirements Resolve performance problems by using plan guides.This objective may include but is not limited to: object plan guides, SQL plan guides, templates plan guides, dynamic management views My Take It seems to me that we will simply be exploring … Continue reading

Posted in SQL | Tagged , , , | 1 Comment

SQL Server 2008 Query Performance Tuning Distilled

SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey and Sajal Dam approaches the task of maintaining and tuning an SQL Server in a methodical fashion, and I highly recommend it.  The book might take a little while to … Continue reading

Posted in SQL | Tagged , , | Leave a comment

Tables – one look only, please – Or using CTEs

This post is in response to a query which I had to investigate earlier in the week which dealt with a number of very large tables.  I had never looked at this particular routine before and was slightly appalled when … Continue reading

Posted in SQL | Tagged , | Leave a comment

ODS Indexes, when should we trash them?

It is said that a fair majority of the ETL process is spent dealing with indexes.  So, how can we decide when to destroy an index and then recreate it after the table is loaded?  Do you maintain these indexes … Continue reading

Posted in SSIS | Tagged , | Leave a comment