Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sql server 2005 partition filegroup   (RSS)
Sorry, but there are no more tags available to filter with.

Should I partition my SQL Server table and how? (SQL Server 2005)

At first, you need to identify if the table needs partitioning. In order to do that, you can run this query to see which tables of the database are the biggest and if there is e.g. a table that takes half the space of the database by itself: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
Page view tracker