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.
How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285
Question: How to Combine Time and Date in SQL SERVER?
Answer: A very simple and popular question. Let us learn together.
SQL SERVER – Computed Column and Compute Scalar Operators
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.
Year-Over-Year Comparisons in One Query
Build year-over-year monthly comparisons with a complete calendar, LAG, date-aligned joins, safe percentages, and missing-period rules.
SQL SERVER – Total Number of Partitions Created by Partition Function
The next task for us was to find out how many partitions so far has been created by the same partition function. Let us learn about that today.
Scalar Function Statistics With sys.dm_exec_function_stats
Read dm_exec_function_stats to rank scalar UDF activity, inspect callers, verify collection settings, and recognize inlined work.