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)
1,307 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,806 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,003 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
As we all know there is already a lot of information available about SQL...
As we all know there is already a lot of information available about SQL...
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
hopefully a quick one This tsql SET IDENTITY_INSERT dbo.tblSCVMatchedv3 ON insert into dbo.tblSCVMatchedv3 select...
Hello Is there an equivalent for monitoring things like IO, reads, writes, ... produced...
Ask SSC