terry999 (3/25/2013)
Say you have a table of sales you could partition on sales date, so have one file per year.Performance would be better for queries in that time period
Partitioning is not about performance, it's about manageability, data loads, large deletes. It may help performance, but it's by no means guaranteed.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
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