Post reply

partitioned tables

  • April 29, 2010 at 4:57 am

    #220096

    Hi,

    I am not very experienced with SQL 2008 but we are about to move to 2008 with full compatibility, we have several tables many GB in size. Could we convert an existing table to a partitioned table? Would any changes need to be made to the application which uses these tables? Or would it still appear as just one table to the application?

    Also how big an operation would it be to convert an existing table to several partitioned tables?

    Many thanks

  • April 29, 2010 at 5:29 am

    #1159567

    Table partitioning feature in there in SQL Server 2008. It will appear as single table only to the application. there is not any impact on application or any database business logic.

    Table partitioing is easy and should not take much time if you read more about it from books online

  • April 29, 2010 at 11:26 am

    #1159931

    read this article, it has detailed information about partitioning.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply