Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.
Patch Your SQL Server – SQL in Sixty Seconds #100
When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
SQL SERVER 2019 – Disabling Scalar UDF Inlining
Working on the Comprehensive Database Performance Health Check, we will learn how I helped a client by Disabling Scalar UDF Inlining in SQL Server 2019.Â
SQL SERVER – Finding Day Name from Date
In today’s blog post we will a very simple script where we will find day name from any valid date. There are multiple ways you can do it.
SQL SERVER – Counter Temp Tables For Destruction Not Working
They realized their counter Counter Temp Tables For Destruction Not Working and wanted me to help them. Let us learn about it today.Â
SQL SERVER Management Studio – Update Column Statistics Via SSMS
Today we will see how we can update Column Statistics via SSMS (SQL Server Management Studio). This feature was broken earlier and now fixed in SSMS 18.6.
SQL SERVER – Input and Output Parameter for Dynamic SQL – Simple Example
Today we are going to a very simple example of the Input and Output Parameter for Dynamic SQL. I have been working on SQL Server for almost 20 years.