Partitioning for Perf and Mgmt of Large Tables

Speaker(s)Eddie Wuerch 

Duration: 60 minutes

Track: Room B

Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours?  Come see what partitioning can provide for you.

Accompanying Materials:

No material found.


SQLSaturday