Recently I was doing a pretty large SQL 2012 deployment, and was doing some research on capacity specifications. There were lot of numbers which I found really interesting and some…

Today I opened SSMS in one of my SQL 2005 box,and to my surprise I got this error right away “The file C:\WINDOWS\Microsoft.NET\Framework\%version%\mscorlib.tlb could not be loaded.” I was running…

From last night I have been doing lot of planning to setup a virtual environment on my laptop.It was kind a little complex one as I will be dealing with 3 VM’s…

Today there was an interesting question on max_files column value which is available under sys.traces view object.The question was like this  – max_files in sys.traces is 0 and that means…

Today I came across some tools which does smart way of formatting your SQL code.Who does’nt like a code which is well formatted and easy to read. I remember my…

Today I was doing some test cases around model database,and was querying some of the tables.I just missed to close that session and was creating a new database. Straight away…

One thing I have noticed in forums is that people are curious about features available with different flavors of SQL Server. Most of the times questions comes like I installed SQL Server…

Today more and more systems are coming with NUMA Architecture and I came across this architecture when I was dealing with wait stats. So whats is NUMA or Non-Uniform Memory…

There was a question from one of the users on buffer storage usage.The question was something like this ‘I want to make a table into buffer storage and keep as…