Table partitioning – SQL Server 2008

Posted: May 10, 2011 in Performance, SQLServer
Tags: , ,

Are you worried with query performance due to huge data in tables, use Table partitioning of SQL Server 2008. It’s easy and very useful.

You can partition data to different db data files stored in different hard disks on the server to increase parallelism with I/O. It’s been simplified in SQL Server 2008 compared to SQL Server 2005/2000. We can use wizard based or script based approach to create partitions on new or existing tables. Refer following links for more info.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s