SqlServerKudos - Partitioning Tricks

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Partitioning Tricks

published 285 days, 4 hours, 43 minutes ago posted by

sa 294 days, 22 hours, 8 minutes ago

Partitioning Tricks

For those of you who are using partitioning, or who are considering using partitioning, allow me to share some tips with you. Easy Partition Staging Tables Switching partitions (or more specifically, hobts) in and out of a partitioned table requires the use of a staging table. The staging table has very specific requirements: it must be completely identical to the partitione...

category: Management | clicked: 2 | | source: sqlfool.com | show counter code

tags: 2008, compression, partitioning, Performance, Performance & Tuning

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos