These 7 Questions about OUTPUT Clause follow my INSERT and DELETE videos. I clarify destinations, triggers and performance scope below.
Create Table From Another Table: What SELECT INTO Copies
To create table from another table in SQL Server, use SELECT INTO with WHERE 1 = 2 or TOP (0) for the structure alone. This post builds a demo table and compares it with its copy column by column. It shows the identity trap, the computed column that becomes plain, and the statements that add keys, defaults and indexes back.
Long-Term Backup Retention in Azure SQL Database
Configure long-term backup retention in Azure SQL Database, inspect retained recovery points, restore a separate copy, and review costs.
SQL SERVER – Unicode Storage and UTF8 Version Limits
nchar and nvarchar are usual types for Unicode character strings in SQL Server. Reader questions prompted my datatype summary.
SQL SERVER – Storing a Non-English String in Table – Unicode Strings
Yesterday I had a meeting with my client Performance Health Check, and they wanted to know how to store a non-English string in a table.
SQL Agent Operators and Notifications: Who Gets the Alert
Configure SQL Agent operators, connect jobs and alerts to email notifications, test delivery, and verify notification evidence.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
To inspect Open Transactions for Session nesting on my connection, I use @@TRANCOUNT. It does not directly inspect another session.