jralston88 (7/8/2013)
2. The supposed OS requirement before upgrading is Windows Server 2003, SP2. The upgrade candidates have Windows 2003 SP1 and Windows 2000 SP4. Is this a concern?
Why aren't you considering Win 2008 or 2012?
Win 2003 is almost out of extended support at this time. We're in the process of trying to get systems off of it not migrating to it.
Edit: I would also like to suggest that when you upgrade the db you go full on and go with compatibility level 100 instead of keeping it at 80 because you think it will simplify the upgrade. I think you'll find very few incompatibilities at 100.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St