>We can not use SQL server table partitioning as we have SQL Server Developer edition
Developer is the same Enterprise, therefore it supports table partitioning. One note though, Developer cannot be used for production.
For "home-made" partitioning: move data beyond 93 days into history tables by setting up a night job.
RDBMS optimization: http://ift.tt/1dBfMua
Disk optimization: http://ift.tt/1k2IhSZ
Memory optimization: http://ift.tt/1k2IiWX
Kalman Toth Database & OLAP Architect T-SQL Scripts at sqlusa.com
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
No comments:
Post a Comment