Remove Leading Zeros in any situation T-SQL
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
2,695 reads
Venugopal Saride
Amazon RDS SQL Server - Drop Database with Mirroring
Dropping database in RDS follows different method than dropping the database in local SQL Server. Below is the command to DROP the database in Amazon RDS EXECUTE msdb.dbo.rds_drop_database N'demodb' GO However when the SQL Server is configured with Multi-zone mirroring, then you need to set the partner to OFF and drop all active connections and […]
2020-01-17
3,872 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