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)
896 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)
1,044 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)
874 reads
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
One of the most powerful permissions available in SQL Server is control. But what...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi , Has anyone tried to do this...I'm trying to select only "new customers"...
Hello, I'm trying to get the server name programmatically. Even after I do this:...
Hello, I'm trying to determine if there's a way to get a server's alias...
Ask SSC