Partitions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Partitions

Author

Topic

xpandre
Posting Yak Master

212 Posts

Posted - 2010-03-27 : 04:33:10

Hello,

Is it not a good practice to switch partition 1 of a partitioned table?

I switch partition 1 to a diff table and then merge that partition with the preceeding one.

Left range partition on a datetime column.

Thanks
Sam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources