November 10, 2015 at 11:30 am
What file Groups should the Clustered and Non Clustered Indexes go when creating a Partitioned Table?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 10, 2015 at 1:17 pm
No simple answer to that. You need to consider why you're partitioning the table, where the files are, what the purpose of the multiple filegroups is and a whole lot more.
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
November 10, 2015 at 2:22 pm
I had written code to archive tables into an Archive Database because some tables are very large and it is having an adverse impact on performance.
That was simple but I'm being ask to implement partitioning.
As far as the file groups it does not make sense. Some indexes are in the Primary File Group and some are not and no one can answer why it was done that way.
I wish that I had better information for you.
Thanks for the reply. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 10, 2015 at 2:38 pm
What is really interesting is that all of the data files are on the same drive.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply