One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. Let us resolve Restore Error.
How to Copy Files in SQL Server? – Interview Question of the Week #257
Question: How to Copy Files in SQL Server?
Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.
Lightweight Query Profiling: Live Progress Without the Old Overhead
Use lightweight query profiling to inspect live operator rows and in-flight plans, while avoiding misleading progress percentages.
GLOBAL_TEMPORARY_TABLE_AUTO_DROP: Keeping ## Tables Alive on Purpose
Understand GLOBAL_TEMPORARY_TABLE_AUTO_DROP, its version and database scope, explicit cleanup, and the risks of shared global tables.
Loading Only New Rows: INSERT SELECT With NOT EXISTS
Make loading only new rows repeatable with NOT EXISTS, EXCEPT, source deduplication, and a unique key that protects the destination.
The VALUES Table Constructor: Using a List as a Table
Use a VALUES table constructor for inline mappings and joins, understand the INSERT row limit, and move larger reusable lists into tables.
How Much Space Does a NULL Take? NULL Storage in Rows
Measure NULL storage in ordinary rows, compare fixed and variable columns, inspect record size, and test sparse and compressed designs.