One Way To Track Row Changes In Place In SQL Server
In this video, I delve into the topic of tracking changes in SQL Server tables using temporal columns, as an alternative to change tracking and change data capture. I explain how adding these columns can help you determine when rows were last modified without the complexity and potential issues associated with full temporal tables or change data capture. By walking through the process of creating a table with temporal columns and demonstrating how changes are recorded, I aim to provide practical insights for those looking to implement more efficient tracking mechanisms in their databases. Whether you're interested in auditing row modifications or implementing custom data movement processes, this video offers valuable information that can enhance your SQL Server management skills.
CHAPTERS
00:00:00 - Introduction
00:00:29 - A-B Testing Overview
00:01:29 - Temporal Columns vs Change Tracking
00:03:12 - Junk Date Column
00:04:36 - Last Modified Date Column
00:05:07 - Inserting Data
00:06:21 - Updating Data
00:07:31 - Data Change Tracking Use Case
00:08:40 - Future Video Topics
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━