We all know that the user mode VAS(Virtual Address Space) limit for x86 bit server is 2GB and the same value for x64 bit server is pretty huge,and its 8…

Yesterday there was an interesting question which was floating around twitter.The question was when was the stored procedure last executed,Is it stored some where? Immediate answer which came to my…

There are couple of new DMV’s which came to my attention today and I would like to share them with you all. sys.dm_os_windows_info: This DMV will get you OS related…