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.
Question: How to Combine Time and Date in SQL SERVER?
Answer: A very simple and popular question. Let us learn together.
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.
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.
I have already blogged about validating positive integer numbers in this post (SQL SERVER – UDF – Validate Natural Integer Function).
In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.