Category: Uncategorized

Adding filters and sorts in SP_WHO2

Have you ever wished if you could have somehow filtered the results from our all time favorite command SP_WHO2 instead of going through hundreds of rows of data. If you copied the results to excel and used sorting and filtering in excel , you are not alone. For those who are not aware of  SP_WHO2
Read More »

Hello world!

Hi. My name is Niraj Kumar and I am from Bangalore, India. I have been working as SQL Server database administrator for last seven years in different organizations. I am going to share solutions to problems which I faced in my day to day work and it took me some effort to find solutions to
Read More »