Read Committed Snapshot Isolation

Read Committed Snapshot Isolation

Read Committed Snapshot Isolation RCSI (Read Committed Snapshot Isolation) is something that makes databases go faster. But today I read a post by Michael J Swart that shows a much needed fix if you want to do ETL from an busy database with RCSI. You need to use WITH(READCOMMITTEDLOCK), if your source table can get […]

Two new procedures

QLPrompt from Redgate proved useful

SQLPrompt from Redgate proved useful Erik Darling has built two new procedures; sp_LogHunter and sp_HealthParser. I’ve tried both, and found one server that had core dumped without anyone noticing (using sp_LogHunter). sp_HealthParser crashed on me, because Last_Execution_time was way before Creation_time. How is that possible? I think both go into my toolbox for future use.Find […]

Two new procedures

Darling Data. Stovi.

Two new procedures Erik Darling has built two new procedures; sp_LogHunter and sp_HealthParser. I’ve tried both, and found one server that had core dumped without anyone noticing (using sp_LogHunter). sp_HealthParser crashed on me, because Last_Execution_time was way before Creation_time. How is that possible? I think both go into my toolbox for future use.Find them at […]