SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Partitioning of MSSQL 2005 DB Expand / Collapse
Author
Message
Posted Monday, May 25, 2009 9:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 29, 2009 1:51 AM
Points: 16, Visits: 120
Respected all

We have 60 gb database which having 20 gb of one table which we would like to partition & make it a different as separate primary or secondary filegroups to improve the performance.


Please suggest

vrijesh
Post #722991
Posted Monday, May 25, 2009 10:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166, Visits: 6,925
Please suggest what? You haven't asked a question.

If you have a table you want to partition, you need to learn how to partition. There are articles on this site and in Books Online that will explain how to do this.
Post #723010
« Prev Topic | Next Topic »


Permissions Expand / Collapse