Home Forums SQL Server 2008 SQL Server 2008 Administration SSIS - Need Recommendations RE: SSIS - Need Recommendations
Koen Verbeeck
SSC Guru
Points: 259085
More actions
September 1, 2013 at 1:31 pm
#1646629
A clustered index on the date makes sense.
You can always add nonclustered indexes if needed to support the reports.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP