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)
5,400 reads
Scripts
Files with larger disk consumption
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)
1,102 reads
Alert DBA - High SQL Server CPU Usage
Collect CPU % for a time period and alert if Average CPU usage is high
2019-01-14 (first published: 2019-01-08)
1,803 reads
Quick SQL connection and process details with current SQL - Version2
Quick check SQL connection and process details with current SQL text
2018-12-06 (first published: 2018-11-27)
1,005 reads
2018-11-30 (first published: 2017-04-01)
1,156 reads
2018-11-29 (first published: 2018-11-23)
480 reads
2018-11-15 (first published: 2018-11-08)
1,617 reads
Automatically Failover (Enable or Disable) Jobs Based on HADR Role
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)
6,176 reads
String Replace in Stored Procedures with Powershell
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
1,278 reads
Disk Space Check
I was using this script to check disk space on individual servers for quite some time. And now since I started to use registered servers for MS SQL, I thought of a little modification to the script.
2018-11-09 (first published: 2018-10-24)
1,183 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Alamat BCA KCP Roxy Mas Telp:0821-8200-203
Telp/Wa 628218200203 Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No,...
Alamat BCA KCP Reg.Tanah Abang Telp:0821-8200-233
Telp/Wa 628218200233 Ps. Regional Tanah Abang Blk. F, Lt. Dasar, Kp. Bali, Kecamatan Tanah...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers