When you right click on a database, and double click "Database Diagram", those objects and perms are created.

You need to be db_owner to create an view a diagram.

Hey Jeff,

I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I...

Here is the link provided by Ola to Microsoft's Index best practices.

https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-2017

It never states reorg at 5% and rebuild at 30%.  That was removed almost 3 years ago.

Microsoft does...

You can speed this up significantly.

STOP REINDEXING.

Back to the original question.  Why are you reindexing?  What benefit are you seeing from reindexing?

Reindexing is not a best practice.

The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking question...

My question is what are you trying to accomplish? How frequently do these indexes get fragmented, and what benefit are you trying to achieve by reindexing them?

As Andreas said, the...

Honestly, these are one more of the many the reasons to stop using maintenance plans.

For starters, you have little control over what it's doing.  In SQL 2014, there is no...

If this is anything like the SharePoint farms I have worked with, there may be a few very busy databases and the...

I recommend reading this.  It's VMWare's recommendation for SQL Server on a VM.

https://core.vmware.com/resource/architecting-microsoft-sql-server-vmware-vsphere

SharePoint requires maxdop to be set...

1. How are you determining the %60-%70 usage? Where are you seeing these values?  Have these values exceeded the baselines for CPU?  Or are you looking at today and it...

Not too long ago, I had a client where EVERYONE is the entire...

NOLOCK was the bane of my existence at my last company.  My predecessor forced the devs to add nolock everywhere.  And regardless of how many bugs and issues that got...

Idea#1

Are these values known?  It looks like there is a "fixed list" of possible values.  If so, then you can skip parsing the string and do a like.  The issue...

I still think you are doing too much of the wrong work.

You need to determine when the patching will occur, and either automatically create a new schedule for the jobs...