Good Morning

Moaning

> SQL Server 2019 now has shorter lines for the public toilet.

Morning

Morning

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?

@Philᵀᴹ And I absolutely love shorties:

that's all there is

Easy: allow no SELECT at all. Even better, allow no access to SQL Server ;)

If they were trying to keep the version secret, they messed up by adding the tag

SQL Server 2012 is quite old, but I'm not sure it's embarrassingly so

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.

Hint: 2008 R2

Hmm, I'm willing to take the hint but I can't quite get it

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).

@Philᵀᴹ They are often offshore "resources" of which the actual client knows nothing.

@Philᵀᴹ Allo Allo

@Johnakahot2use Was stuck on 2008R2 in my previous gig

Was no point upgrading it, as we were binning SAP off

@Philᵀᴹ hip-ray, hip-ray, hip-ray

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

Or would I have to search each individual CUxx?

@TomV why did you have to show me that abomination of a question?

I made the mistake of engaging with comments to try to explain why it was a shitty question

I should not have done this

Why are comments even legal