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.
They realized their counter Counter Temp Tables For Destruction Not Working and wanted me to help them. Let us learn about it today.
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.
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.
The question was is there any way to list all the IP addresses which have access to the Azure Firewall and remove them via T-SQL in SSMS.