Posts Tagged ‘vldb’

Resource Governor Basics

Thursday, July 16th, 2009

In very large databases, ad-hoc user queries can easily run on for minutes or hours.  Patient users often kick off long reporting queries and then walk off to get coffee while their queries run on endlessly.  We call these queries zombies.  Your weapon against the zombies is the Resource Governor, new in SQL 2008.  Learn how to use the shovel in this video.

Get the Flash Player to see the wordTube Media Player.

For more about the Resource Governor and other VLDB tips, check out our Very Large Databases wiki article.

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Tags: ,
Posted in Podcasts, SQL Server 2008 | 1 Comment »

SQL Server VLDB Partitioning Tutorial

Tuesday, July 14th, 2009

Tables with hundreds of millions of rows or billions of rows need a way to manage that data easier.  SQL Server 2005 introduced partitioning, and it’s been improved ever since.  Learn about how to implement it in this ten-minute training video.

Get the Flash Player to see the wordTube Media Player.

For more about SQL Server table partitioning and other VLDB tips, check out our Very Large Databases wiki article.

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Tags: ,
Posted in Database Design, Podcasts | No Comments »