Additional Info: Some are relating this problem to the installation of KB4055532
Source: https://www.reddit.com/r/SQL/comments/7ph1ru/ssms_2014_express_impossible_error/

Microsoft SQL Server Management Studio                        12.0.5207.0
Microsoft Analysis Services Client Tools                        12.0.5207.0
Microsoft Data Access Components (MDAC)                        6.1.7601.17514
Microsoft MSXML                        3.0 5.0 6.0
Microsoft Internet Explorer                        9.11.9600.18816
Microsoft .NET Framework                        4.0.30319.42000
Operating System                        6.1.7601

Better, Faster, or Cheaper is a euphemism generally applied to a point-in-time analysis of a problem. It really doesn't apply when considered over any technologically relevant time span, as you...

Subtle push? More like an overt attempt to sell an ostensibly benefit for even more access and control over private data by not-always-visible entities (read what security experts are saying...

Uuups, on my previous comment I had to make a change to the unit tests (after the UDF definition). I didn't use the variable @dt in all cases...

Its interesting to see how other people solve the same types of problems.

Usually when the business calls for a GROUP BY around date/time components I see something like (in this...

Hello Jeff.

Thanks for the links. I am very familiar with this subject and have personally learned these lessons over the years, embarrassingly at times:w00t:

You correctly point out that I seem...

lol, we've come full circle. The original intent of my question was to stretch the boundaries of what was/is...

Sorry for the late reply I've been working around the house and missed your response.

Please allow me a little setup:

Most SQL programmers will tell you that there are two types...

Thanks Chris,

I'm familiar with this technique however it only applies to a certain category of non-determinist problems; namely those where the unknown quantity of elements is in the provided row...

One of my first attempts at splitting delimited data in a column used the XML shred method. Even on relatively small tables (by row count) the queries took forever due...

From my experience, and as any experienced DBA/Programmer would know, you should test everything at a statistically relevant level, i.e., average over multiple tests and eliminate unexplained outliers (if you...

Over the years I've noticed this and other anomalies regarding (n)VarChar.

Another is that (n)VarChar(max) is the black-sheep of the SQL data-types in that intrinsic functions will work with it but...

Yes, unfortunately I only have access to SQL Serer 2005 64-bit servers so I couldn't test it on a 32-bit server, but...

FYI,

DBCC InputBuffer(54);

is problematic. It may be better to use the following as it can be used in a row set query:

Select

s.session_id[SPId]

,SubString

(

st.text,

(r.statement_start_offset/2)+1,

((Case r.statement_end_offsetwhen -1 then DataLength(st.text)else r.statement_end_offset End-r.statement_start_offset)/2)+1

)[Command String]

from sys.dm_exec_sessions...