Michael J. Swart

This is an update to my post last week Partitioning a Huge Table where I talk about taking an existing table and making it partitioned.

Aaron Bertrand wants you to consider using partitioned tables and the sliding window pattern to help archive old data.

Takeaway: Adding foreign keys require schema modification locks on every table involved.

It’s hard to destroy data.

Hey what’s up?

For T-SQL Tuesday, Brent Ozar asked us to write about the most recent ticket we closed.

MIN_ACTIVE_ROWVERSION() is a system function that returns the lowest active rowversion value in the current database.

Takeaway: If you want to extract rows from a table periodically as part of an ETL operation and if you use Read Committed Snapshot Isolation (RCSI), be very careful or you may miss some rows.

When I deploy database changes, I like my scripts to be quick, non-blocking, rerunnable and resumable.

In the past I’ve written about monitoring identity columns to ensure there’s room to grow.