It horrifies me every time I see a terrible question on this site that is clearly about stock trading or something else heavily financial. If you care about your data, and therefore money, spend a bit more on your employees and hire the right people?
I think to me SQL Server 2000 seemed old in 2007 to a greater degree than SQL Server 2012 does now, even though it was the penultimate version at the time, unlike the 2012 now.
I thought 2008 R2 was the best SQL Server version out there, and it somehow never seemed to age at the time. Was still going strong until last year (2018).
Quick question: Does anybody know of a summary of CUxx for SQL Server 2016 and what they do/did?
I'm still banging around with a database that is (apparently) performing bad since we moved it to SQL Server 2016
Wouldn't you with 97% adhoc plans?
Anyhow, I've seen that the latest CU10 has some fixes regarding performance issues with tables with covering indexes:
> FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi-column statistics