Hundreds of Views and no idea which are indexed? A quick query on sys.views lists every view with its schema and whether it is indexed or indexable.
SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage
My SQL puzzle: which queries create the most TempDB IO and grow its size? Answer with any DMV, and all valid answers get published here with credit.
hierarchyid GetLevel: Count the Path Depth
hierarchyid GetLevel identifies depth within a logical path. The read-only example distinguishes the root, children, grandchildren and a fractional sibling label.
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
Two DISK targets in one BACKUP command split the file, they do not copy it. Learn how a mirrored database backup takes multiple backups in a single command.
Stored Totals: Find Drift Before Repairing It
Stored totals can drift from their authoritative line amounts. This private demonstration finds two mismatches, retains empty orders and accepts valid credits. It checks decimal range before a private repair and explains why concurrency needs separate proof.
SQL SERVER – Change Column DataTypes
A simple way to change column datatypes in SQL Server with ALTER TABLE ALTER COLUMN, shown on a sample table and checked with sp_help.
SQL SERVER – System Stored Procedure sys.sp_tables
Most people run SELECT * FROM sys.tables to list tables. If you do not need all those details, sys.sp_tables returns tables and views with schema names.