Month: July 2021

Stop using sp_hexadecimal & sp_help_revlogin

July 6, 2021 Andy 2

Since I started at Stack Overflow, I’ve had the chance to see some of the interesting challenges with running our databases at our scale. My coworker Taryn Pratt (blog|twitter) recently blogged about fighting with deadlocks related to Stack Overflow for Teams. Lots of logins Taryn … [Read More]

Identify all tables with an identity column

July 2, 2021 Andy 0

Question Is there a query I can run that will show me all tables with an identity column? Trying to figure out if there are any identity based tables whose current identity is nearing upper bound of int32 or int64. asked 2021-07-02 by user2368632 Answer … [Read More]