Hi Steve...

Thanks for taking the time to write and publish this article.  I am curious, though.  What is the link to Brent's article?

5% doesn't prevent you from rebuilding an index.  The settings you pass to your defrag software might.

The term "corrupted" is the wrong term here.  The index is not being corrupted. ...

Any format containing yyyy-mm-dd can also throw you for a loop if the data had French origins because SQL Server uses YYYY-DD-MM with the French Language.

There is NO WAY to...

What do you mean by "As the data moves on the pages the index is getting corrupted"?

I have a database that has monthly backups of a table for the past five years... i.e., they copied the table at the end of the month to a...

Actually, it's the perfect job for SQL Server.

To answer both of your questions for what I'm currently doing... 100% on-prem for SQL Server.

As for the MS versions of machine learning in general, the only thing I've done...

If I had to guess, my guess would be that they're using the default settings instead of actual settings.  That's terrible, of course, but I see little that can be...

Thanks, Luis.  I appreciate the feedback.  If you get the chance, let us know how it all works out for you even if you don't use the code I posted...

Concerning nvarchar (Max), it's an ill-conceived notion to applying this at all except if you hope to have in excess of 3000 characters. Just check indexing and varchar (max),...

To be honest, you don't have to do a thing.  SQL Server will flush the buffer pool based on the work load and what fits into memory all on its...

Hi,

both will work perfect. There is no difference wrt performance also. I have seen in some community posts that select 1 is faster than select * but if you...

Crud... ok... it turns out that my other databases are actually being affected.  They're just large enough to make it look like the percentage of unused space is quite small. ...

I have a VARCHAR(n) field [sic: columns are not fields!] that is the description of my product like these 2 ones:

Ref Design

2566000 Sandália BEBE 19/24 Cx12

2578995 Chinelo M/ Dedo...

I think that point #3 is the most important of all... and it should not only come with the same warnings as a chainsaw but should clearly state that if...