A short demo of a CTE used to perform aggregations.
2019-04-16 (first published: 2019-04-12)
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
Through the shared script, you can see the Paglock table hint.
2019-02-27 (first published: 2019-02-20)
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
2019-01-15 (first published: 2019-01-08)
Collect CPU % for a time period and alert if Average CPU usage is high
2019-01-14 (first published: 2019-01-08)
Quick check SQL connection and process details with current SQL text
2018-12-06 (first published: 2018-11-27)
A TVF to select prime numbers
2018-11-30 (first published: 2017-04-01)
Starting from a string, it returns values embedded in delimiters.
2018-11-29 (first published: 2018-11-23)