This script will provide a list of indexes that are not used in a database. Indexes are overhead and any indexes not being used but are being updated cause additional load on a database. This looks at the following items: User seeks, scans and lookups. If all three of these are zero and the User […]
2020-04-21 (first published: 2020-04-13)
2,342 reads
This script on missing indexes that SQL had found. SQL will track queries and provide suggestions on indexes it feels will provide improvements. You should not take this information and create all the indexes. Performance tuning can be an art and takes practice. This information should be reviewed and as a DBA implemented a little […]
2020-04-20 (first published: 2020-04-13)
3,936 reads
Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.
2019-08-20 (first published: 2019-07-26)
1,289 reads
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
I know there are lambda versions. But I want to know if this can...
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
I'm in the process of replacing a sql server 2012 with 2019. How do...
Ask SSC