Configure SQL Agent operators, connect jobs and alerts to email notifications, test delivery, and verify notification evidence.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Nested Transactions are Myth – SQL in Sixty Seconds #125
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
To inspect Open Transactions for Session nesting on my connection, I use @@TRANCOUNT. It does not directly inspect another session.
SQL SERVER – Simple Recovery Model and Restrictions
Simple Recovery changes recovery options before it changes a performance diagnosis. I choose it from the agreed recovery requirements.
Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124
Is dropping temp table in stored procedure code really needed? In this SQL in Sixty Seconds video, I compare two procedures to show what happens.
FORCE_DEFAULT_CARDINALITY_ESTIMATION: A Simple Explanation
FORCE_DEFAULT_CARDINALITY_ESTIMATION is a query hint that gives one query the default cardinality estimator, even when the database is set to the legacy one. This post builds a demo table, compares the row estimates of both models with the real count and shows how to prove which model a plan used. It also names the opposite hint and the permission difference.
What is Temp Stored Procedures? – Interview Question of the Week #294
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.