End of Support does not shut down SQL Server, but it changes security updates, fixes, and help; plan an exit before risk grows.
SQL SERVER – Index Created on View not Used Often – Limitation of the View 12
At my Hyderabad seminar someone asked: will an Index Created on a view be used when you query the view? Not always. Limitation 12 of views explained.
SQLAuthority News – A Successful Community Tech Days in Ahmedabad – December 11, 2010
Nearly 170 people joined a successful Community Tech Days in Ahmedabad with Jacob Sebastian, Rushabh Mehta, Vinod Kumar and me. Here are the details.
SQL SERVER – Server Side Paging in SQL Server 2012 Performance Comparison
A quick performance comparison of server side paging in SQL Server 2012, split into two tests, with a focus on the unnecessary IO reads that make paging costly.
SQL SERVER – Server Side Paging in SQL Server 2012 – A Better Alternative
Server side paging in SQL Server 2012 is simpler with OFFSET and FETCH NEXT. I compare it with the older ROW_NUMBER and OVER method from SQL Server 2005/2008.
SQL SERVER – What the Business Says Is Not What the Business Wants
Let us discuss about What the Business Says Is Not What the Business Wants. Steve raised a very interesting question.
SQL SERVER – What is Page Life Expectancy (PLE) Counter
What is Page Life Expectancy (PLE)? A quick query to read it from sys.dm_os_performance_counters, the recommended minimum of 300 seconds, and what it means.