Unused Indexes

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: )

896 reads

Missing index script

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: )

1,044 reads

Blogs

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

What is the CONTROL permission?

By

One of the most powerful permissions available in SQL Server is control. But what...

Daily Coping 19 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Select "New Customer"

By gjoelson 29755

Hi , Has anyone tried to do this...I'm trying to select only "new customers"...

Get local server's alias in T-SQL

By schleep

Hello, I'm trying to get the server name programmatically. Even after I do this:...

Get local server's alias in T-SQL

By schleep

Hello, I'm trying to determine if there's a way to get a server's alias...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers