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,129 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,423 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)
967 reads
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...
By Will Assaf
On July 27, Christine and I will present our joint presentation on Ethics in...
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
i have a formula that calculates the difference between two dates and tells me...
I trying to figure out what percentage of the total charge for a ME...
I am trying to create groups for each Name and save the max and...
Ask SSC