2016-10-28 (first published: 2016-10-05)
23,089 reads
Scripts
Getting top ranked employee detail for each department
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
840 reads
Extracting only Deadlock details from ErrorLog
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,945 reads
2016-10-21 (first published: 2015-05-12)
2,434 reads
2016-10-20 (first published: 2015-05-15)
1,665 reads
Calculate two internships
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2016-10-19 (first published: 2016-10-03)
530 reads
Copy Backup Files to Remote Shared Location and Delete them periodically
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
2,116 reads
2016-10-17 (first published: 2016-10-03)
893 reads
Recompile All Databases stored Procedures
When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures
2016-10-14 (first published: 2016-09-26)
4,433 reads
Expand Template with Values from Result Set
This stored procedure extracts template variable names and values from a SQL result set in order to process the template.
2016-10-13 (first published: 2016-09-14)
385 reads
Blogs
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...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers