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.