February 10, 2012 at 9:27 pm
What are the steps necessary to partition tables and databases?
February 11, 2012 at 3:49 am
You can't partition databases.
For databases with multiple files/filegroups (which I suspect is what you meant), see Books Online "Files and Filegroups"
For partitioned tables, see Books Online "partitioned tables", it's a complex subject.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2012 at 6:09 am
Or logical partitioning...
User-Schema Separation
February 11, 2012 at 7:15 am
Rowles (2/10/2012)
What are the steps necessary to partition tables and databases?
1- In regards to tables... plenty of documentation on the net - for a general view (don't be lazy) check Books On Line, then come back with specific questions 😀
2- In regards to databases... as pointed out by Gail you do not partition databases but perhaps you are talking about Federated Databases? Doubt it but if that's the case start here: http://msdn.microsoft.com/en-us/library/ms190381.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply