Simon's SQL

DevOps, Kubernetes, AI/ML and database platform notes from Simon Cho — AVP of DevOps & DBA at Nowcom, PASS Summit speaker.

Home
About
Talks
Archives
Search
1. Dark Mode

Search

Archives

Categories

T-SQL & Scripts Community & Talks Troubleshooting Performance & Tuning Administration & Tools Backup & Recovery Containers & DevOps High Availability

Tags

SQL Server SQL Saturday Minimal Logging Replication Backup Backup Chain Broken Blocking Compression Index Rebuild Intel CPU JOB Kubernetes Log Shipping Broken Meltdown PowerShell RAISERROR Spectre SQL Server 2016 SQLAngeles SQLAngeles.com Statistics Update T1118 TempDB Transaction

Tags

1 page

XACT_STATE

XACT_STATE or @@Trancount (To control Nested Transaction)

© 2011 - 2026 Simon Cho

Simon Cho · simon@simonsql.com
Built with Hugo
Theme Stack designed by Jimmy