SQL Server 2008 adds Backup Compression. I back up AdventureWorks with and without compression, compare file sizes and show how to turn it on at server level.
SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
SQL Server 2008 lets you insert multiple records using one INSERT statement with a row constructor. I compare it with separate INSERTs and the UNION ALL method.
COLLATIONPROPERTY CodePage: Identify Text Encoding
COLLATIONPROPERTY CodePage reports varchar encoding metadata. Compare code pages 1252 and 65001 without confusing inspection with text conversion.
DATEPART Quarter: Keep the Year Beside the Quarter
DATEPART quarter identifies a calendar component. I keep its year when reporting separate periods. A cross-year January case shows how quarter-only grouping combines events.
A One Page Reference for Everyday SQL Server Work
Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.
SQL SERVER – Find Current Identity of Table
Many developers use MAX() to find the current identity of a table. I prefer DBCC CHECKIDENT, which reports the current identity value directly.





