June 16, 2015 at 6:26 am
TomThomson (6/5/2015)
Braindead comment removed. Must remember to switch brain on before applying fingers to keyboard.
Don't worry. We all do that (forget to switch brain on) sometimes. @=)
June 16, 2015 at 7:35 am
Jeff Moden (6/3/2015)
David Burrows (6/3/2015)
Jeff Moden (6/3/2015)
If the PeriodNo is ever increasing, then yeah, I agree.
Thanks Jeff
Yes PeriodNo will always be increasing
I will go with Tom's suggestion 🙂
Just one more addition... if the two columns that Tom suggested do NOT make for a UNIQUE clustered index, consider adding the UploadID column as a 3rd column to the clustered index to make it unique and then define it that way. SQL Server has a mighty big love for unique clustered indexes.
Heh... speaking of engaging the brain, I went back through this thread and found that you, yourself, had suggested the very thing. :pinch:
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply