Introduction For one customer I just transferred a troubled 2TB table (2 billion rows) into a monthly-partitioned table in just 2.5 hours and no downtime! To make things more difficult, within that time additional deduplication had to be performed, as …
Want to learn SQL and need some guidance? SQL is the language you communicate with most of databases today, including SQL Server.
Row Version Store We know RCSI (Read Committed Snapshot Isolation), as well as SI (Snapshot Isolation) use row versioning to store previous verions of rows in part of tempdb called “row version store”. If you are using default isolation level …
RCSI and LOB data – how tempdb version store is used? Read more »
