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.
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.
SQL SERVER – UDF – Validate Natural Integer Function – Simple Version
I have already blogged about validating positive integer numbers in this post (SQL SERVER – UDF – Validate Natural Integer Function).
SQL SERVER – List Database Available for Current User – HAS_DBACCESS
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.
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
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.
SQL SERVER – Count NULL Values From Column
I have received a very simple but interesting question by one of my earlier clients about how to count NULL values from the column.
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.