best practice

Don’t do these things in SQL Server

by Randolph
August 1, 2018August 30, 2018

Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored for a SQL Server audience.… Read More »Don’t do these things in SQL Server

Max Server Memory Revisited

by Randolph
August 30, 2016August 30, 2016

Some time ago, I added a free resource to this site to help DBAs know how much max server memory should be assigned to SQL… Read More »Max Server Memory Revisited

On Best Practices

by Randolph
April 26, 2016April 28, 2016

We hear a lot about “best practice”, but what does it mean in the context of SQL Server? Wikipedia describes best practice as follows: A… Read More »On Best Practices