Writing a CTE name two times can mean doing the work two times. Two small demos show when a temp table helps and when it only adds cost.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table
Part 2 of my FileTables series covers two methods to insert data into a FileTable in SQL Server 2012, starting with a simple copy and paste.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment
Part 1 of working with FileTables in SQL Server 2012: what a FileTable is, why it helps with file data, and how to set up the environment.
Building an Org Chart Query With hierarchyid
Build an org chart with hierarchyid, query descendants and levels, move a team safely, and compare it with recursive queries.
Storing Durations and Summing Time Past 24 Hours
Use whole seconds for summing time beyond 24 hours, aggregate safely, format unlimited hours, and convert legacy time values.
Installing AdventureWorks Sample Database: SQL in Sixty Seconds #010
Installing AdventureWorks is one RESTORE statement, and a few checks before and after it prevent the common failures. The tests here read a backup header and file list, restore under a new name with MOVE, and confirm the result on SQL Server 2025.
Modeling Friends and Followers With SQL Server Graph Tables
Build SQL Server graph tables for follows, mutual connections and friends of friends, then use shortest paths and compare a junction table.