Sqlism (4/30/2013)
Thanks Paul for your time.If i have data for Eg from
2009
2010
2011
2012
2013
How should i plan the partitioning for unexpected data where the date is like 1988 or 2050
Create a partition that catches data with dates to the left of 2009/01/01 for th 1988 alike data and a partition that catches data to the right of the top year on your schema
http://www.databasejournal.com/features/mssql/partitioning-in-sql-server-part-3.html
_____________________________________
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.