There are localization differences for the default code page when doing certain type conversions. I was wondered if collation is where that came from when a string is implicitly converted...

One of my biggest pet peeves about (small)datetime is its handling of the format yyyy-MM-dd( hh:mm:ss) as it is ambiguous. For those using American as their language they are...

check your vlfs as well

DBCC LOGINFO

I generally aim to have less than or equal to 40 or 50 vlfs, I wouldn't of my way to do anything about it unless...

My statement was...

My statement was...

MY SQL command for a data scientist would be to stay away from querying my SQL server and use the models the organization spent cumulative millions on developing.

SQL is supported back only for two previous cumulative updates. If you need security updates or bug fixes, or support from Microsoft beyond that, install the CU.

Getting back to this post, if you know how to think and how to write good T-SQL (accurate, performant, well documented with comments, and well formatted for readability),...

I guess if you fantasize that UPSP standards aren't standards, you would have to use a number.  Everyone in the country should know that state TX represents.  What is state...

It's 16 Gb. My laptop from 10-11 years ago had double that amount of ram. My phone from 2010ish with its 480x800 resolution screen had that amount of...

It's 16 Gb. My laptop from 10-11 years ago had double that amount of ram. My phone from 2010ish with its 480x800 resolution screen had that amount of storage.

Maybe you...

How about let's work on your ability to state things without inferring meaning?

You stated "A clustered...

I read everything you wrote. ...

Let us work on your comprehension and failures in logic and reasoning then.

I wrote "A clustered Primary key is a unique clustered index."

You suggested that meant a unique clustered index...

I mean you literally quoted all the constraints I mentioned on it I cannot possibly imagine how you failed to understand what I wrote.