Summit Resources

Here you can find an assorted list of blog posts and external references pertaining to the presentation I gave at PASS Summit 2009. The presentation was entitled, “Super Bowl, Super Load – A Look at Performance Tuning for VLDB’s.”

Database Design

• Performance Considerations of Data Types
• Overhead in Non-Unique Clustered Indexes

Partitioning Resources

• Partitioning Code Example
• Indexing for Partitioned Tables
• Partitioning Tricks
• Partitioned Tables and Indexes in SQL Server 2005 (White Paper by Kimberly Tripp)

Indexes

• Index Defrag Script v3.0
• Index Clean-Up Scripts
• A Look at Missing Indexes
• Filtered Indexes: What You Need To Know
• Find Missing Indexes in Stored Procs with T-SQL

Bulk Operations

• One-to-Many Inserts with Table-Valued Parameters
• Bulk Inserts with XML
• BCP Basics

• Categories

  • Business Intelligence
  • Internals
  • Miscellaneous
  • PASS
  • Performance & Tuning
  • Presentations
  • SQL 2008
  • SQL Tips
  • Syndication
  • T-SQL Scripts

• Subscribe to my blog!

  Like what you see? Subscribe!

  It's easy, free, and will keep you informed of my latest SQL tips and scripts.

• Around the Web

  Follow me on Twitter!

   

  

  I'm also a Contributor at SQLServerPedia.com

• Recent Tweets

  • @dzesika Suuuuure, rub it in that you have a window. On the other side of things, it's -1 degrees outside & I have a fan on :)
  • @BenchmarkIT Merry Christmas to you, too, Colin! :)
  • @robboek Apparently I'm even farther behind than I thought! Good to know there's more psychotic goodness to watch over the holidays #Dexter

• Archives

  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008

• Recent Posts

  • Replication Bug with Partitioned Tables
  • Live Blogging: Women In Technology Luncheon
  • Live Blogging: Keynote at PASS, Day 3
  • Live Blogging: Keynote at PASS, Day 2
  • Live Blogging: Keynote at PASS, Day 1

• Most Popular Posts

  • Index Defrag Script
  • Error Handling in T-SQL
  • Index Clean-Up Scripts
  • BCP Basics
  • Bitwise Operations

• SQLRockstar Blog Ranking

  

• Tags

  .NET380PASS2008bibitwiseBOLbooks onlineBusiness IntelligencechainbloggingcontestdefrageventsfragmentationgaminghumorindexesInternalslargelive bloggingmaintenaceMiscellaneousmissing indexesmonitorpagespartitioningPASSperformancePerformance & TuningpresentationreplicationscriptSQL QuizSQL ResourcesSQL SaturdaySSMSSummitSuper BowlT-SQL ScriptstagtipsTSQLtuningundocumented commandswebcastXML

• Obligatory Disclaimer

  The views expressed on this website/weblog are mine alone and do not necessarily reflect the views of GoDaddy.com, Inc. or its affiliates.