Ranking has improvement considerably from SQL Server 2000 to SQL Server 2005/2008 to SQL Server 2012. Here is the blog article where I wrote about SQL Server 2005/2008 paging method SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table. One can achieve…

During performance tuning consultationconsultation, there are plenty of counters and values, I often come across. Today we will quickly talk about Page Life Expectancy counter, which is commonly known as PLE as well. You can find the value of the PLE by running the following query. SELECT [object_name], [counter_name], [cntr_value]…