SQL SERVER ON LINUX
January 6, 2017
If someone want to find out duplicate rows can use this SELECT statement!
If SELECT displays same records, you can use this DELETE statement below:
I know that it is trivial but it can be very helpful!
How to find out estimated saving space for Data Compression for all tables in the database?
March 7, 2019
Resumable Online Index Create in SQL Server 2019
January 13, 2019
SQL Server 2019: New features!
January 10, 2019
How to configure Dynamic Data Masking?
January 8, 2019
How to implement Always Encrypted?
January 6, 2019
How to identify memory bottlenecks in SQL Server with DMV?
December 19, 2018
How to increase data and log files by 25% of their total size for all databases?
December 17, 2018
Problem after migration from compatibility level 100 to 120.
December 14, 2018
How to grant "Execute" permission for User Defined Table Type?
June 2, 2018
Daily use in Management Studio - #3 Query to find running queries via T-SQL
May 13, 2018