Creating Partitioned Table in SQL Server 2005

SQL Server 2005 supports partitioned table to enable database developer to separate tables horizontally to different file groups. This post shows how to create partitioned tables in SQL Server 2005.                     Click “Start”, click “All Programs”, move your mouse on “SQL Server 2005” and then click “SQL Server Management Studio” in the context menu.   Connect to SQL Server 2005 with a Windows account or SQL Server account with adequate privileges. (It’s OK for you not to connect to the server at this time.. However, you need to connect to the server with an appropriate account when you want to … Continue reading Creating Partitioned Table in SQL Server 2005