Helping Out

I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing a lab environment, I think it deserves its own blog post.

Here are the chronicles of my struggles to add a large Clustered index to a View without causing an outage.

Have you ever encountered a situation where you mark the constraint as trusted, but the next day, it’s back to untrusted again? This blog post will help you find the cause.

When you look at the Extended Events in the SSMS, is it a local time or server time? Let’s find out.

How can 15 be less than 13? Let’s have a look at this unexpected, but fully documented behaviour.

I’ve come up with an efficient way to monitor only specific data changes in a table.

I was investigating a mysterious Intent Shared lock in a deadlock report. Especially confusing, since the database was using an Optimistic Concurrency.