Since RedGate owns SQLServerCentral.com, a burning question comes to mind and that is, "What privs level does RedGate's "monitor" product require"?

I am thinking of using full text search, but full text search does not allow leading wildcard, a search for "phone" will not return any record. What can I...

If you have some indexes that have woefully low (less than 80% average percent of page fullness [page density]), then rebuild (NOT reorganize) them at 82% to...

Actually, it's...

I strongly recommend against that.  If you're waiting for a 50-80 mix of fragmentation, you've already waited for most of the fragmentation to happen.  This is now in the "why...

My favorite of all time actually has nothing to do with SQL Server.  It was a post (wish I kept the link) about an HP printer tech that was trying...

There are way too many threads...

Of course not... they're too busy trying to meet a usually impossible schedule...

They say, we are busy with so many projects going on and...

No.  It is not "correct".  The correct answer is "It Depends".

It depends both on the data in the table, they key column(s) you've selected for the Clustered and Non-Clustered indexes,...

If you want coded help, please see the article at the first link in my signature line below for one way to create "Readily Consumable Data".

Sounds like a road trip to the data provider with a pork chop cannon may be in order. 😀

Yeah... I know.  It didn't work for me either. All I got...

BWAAAA-HAAAAAA!!! Some of my fellow older folks in the crowd will have an appreciation for what...

Here is another example based on what I found to day:

SELECT char(n) FROM numbers WHERE n BETWEEN acsii('A') AND ascii('Z')

In the actual example I found when...

First of all, I saw that we have Amazon RDS for SQL Server.

Regarding script for index maintenance (https://ola.hallengren.com/) it looks like the same as what I want to...

Same to you, Jo!  To you and all the other denizens of this fine forum, I hope this post finds all of you and yours in...