I guess my question is, what have you tried?  I see no limitations in the documentation for the likes of VARCHAR(MAX)...

Now that's super interesting.  Thanks for taking the time to explain all that, Frederico.  I really appreciate it.

To be honest, I've never needed the 32 bit version and so I've never tried to install it in parallel with the 64 bit version.  That being said, you've piqued...

That's not the intent of the "quiet" switch.  The intent is...

Also, for child tables in particular, the typical usage would be a seek and then a scan of contiguous rows.  In those situations, any significant logical fragmentation COULD cause...

With the exception of random but evenly distributed indexes, I wouldn't use logical fragmentation to determine if an index needs to be rebuilt.  In the case mentioned,...

I believe you'll find the following article quite interesting.  To summarize, Paul White proves that the 5000 row thing is a bit of a myth that, according to him, no...

Ah... almost forgot about another scenario that I ran into.  Are the connections to the server setup to explicitly turn off/disable M.A.R.S.  It they're not, they need to be.  The...

Thank you.

Not after the Index maintenance job. I check the queries that are consuming for years. They are not new o nes. I tried  updating the stats & cleared...

Logical fragmentation is seriously overrated as a concern.  As Grant said, unless you can seriously prove that it's causing an issue, don't worry about it.  I'm working on some articles...

And don't forget the veterans that missed so many holidays nor the folks that are on active duty.

And, if the update is rolled back instead of  being committed because the error was realized, then the second query has just returned incorrect information. 😛

My problem with Query Store and some of the people that use it is that, quite frequently, many of the plans (there's just 2 or there's more) are terrible.  A...

Show me where in Table "A" that you have the value "DEF0002".

I think your example data for Table "A" is incorrect.

Sounds like it's time to...