SQL SERVER ON LINUX
January 5, 2017
I needed to delete all the databases on Instance, therefore I wrote my favorite Cursor. In this case it is a very simple cursor. To delete the database we use DROP DATABASE < name of DB > statement.
You can use this Script below:
See you later!
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