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.
SQL SERVER – Display Rupee Symbol in SSMS
Just instead of US Dollar Sign ($), they wanted to display it with Indian Rupee Sign (₹). Let us learn today how we can Display Rupee Symbol in SSMS.