@Everyone...

Any help here on this question?  I've not used DDM and so I'm only able to shoot from the hip based on what the documentation says.

Again, I've not used DDM but, according to the documentation, it looks like the only function that will work with the IMAGE datatype is the DEFAULT function.

As for backups and...

The only thing that I can guess is either connection leaks or memory leaks cause by the application(s).

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