I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a search...

You'll be better off posting a topic about your scenario then, Paul. The OP here appears to have been explicitly trying to use the tabular model on a standard instance,...

Tabular Views is an enterprise feature only.If you need to use use...

Is this person in way over their head?  It seems like he was dumped in a closet and given orders to find out everything.  He's been pretty prolific with...

You can find a list of the build numbers, for all versions, here. In recently history, the only version that have had a "major" version revision is SQL Server...

Entertain us, post those execution plans; either as an attachment or using a tool like

"Microsoft OLEDB provider for SQL server" is the one you want. If you've selected that one, try it, it'll work.

So, I interview today for a potential position and at the end of the interview I am offered the position. I start work with the new company on November...

Yes, I know this and it's implied in the OP due to me explicitly comparing LEN to DATALENGTH and no even entertaining the...

DATALENGTH() is supposed to return the byte length of the entire value.  Is is not doing that?  MS's doc seem to imply that it should (then again, we've all...

Is your db at compatibility 150 level?  I know it almost certainly is, but I'm trying to think of anything that might cause DATALENGTH() to not work correctly (and...

• This reply was modified 5 years, 7 months ago by Thom A.

I wonder if Steve Collins got "lost" and thought they were in a different thread? Either way, it's completely derailed my original question. 🙁

My point is that those 2 business partners are running a complete and utter all out...

I'm not sure of your point here.

... sigh... The ?? in the above is not actually ?? it's a smiley face emoji; seems that SSC stores posts in a varchar column and the value is lost....