Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
3,449 reads
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
3,449 reads
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)
962 reads
Collect CPU % for a time period and alert if Average CPU usage is high
2019-01-14 (first published: 2019-01-08)
1,471 reads
Quick check SQL connection and process details with current SQL text
2018-12-19 (first published: 2018-11-27)
925 reads
2018-11-30 (first published: 2017-04-01)
859 reads
2018-11-29 (first published: 2018-11-23)
423 reads
2018-11-15 (first published: 2018-11-08)
1,467 reads
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
2,779 reads
Create the code to detect and repair non trusted foreign keys
2018-11-13 (first published: 2018-09-27)
425 reads
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
800 reads
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers