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.
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.
Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.