T-SQL query to get the latest available backup chain
T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.
2019-10-30
9 reads
T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.
2019-10-30
9 reads
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...
2019-10-30
15 reads
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...
2019-10-30
10 reads
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...
2019-10-30
18 reads
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...
2019-10-30
16 reads
2019-10-10
34 reads
2019-10-10
12 reads
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
767 reads
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
83 reads
WHILE LOOP can be used for batch processing and can be helpful if you are dealing with huge data processing. Recently I did an analytics project where I had...
2019-10-09
15 reads
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Jl. Temiang No.27, RW.29, Tanjungpinang Bar., Kec. Tj. Pinang Kota, Kota Tanjung Pinang, Kepulauan...
Tlpn/wa0853.7373-7551 Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec....
Jl. Sunaryo, Kemboja, Kec. Tanjungpinang Bar., Kota Tanjung Pinang, Kepulauan Riau 29112
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers