SQL Performance Archives - Page 62 of 100 - SQL Authority with Pinal Dave

SQLAuthority News – 18 Seconds of Fame – My PASS Experience

December 25, 2010

Personal, SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Happy Holidays to All of YOU! Life is full of little and happy surprises. I think Christmas and Santa are based on it. I just received very interesting email earlier today, I had no idea about it. Earlier this year, I had visited Seattle to attend SQLPASS – read the…

SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2

December 23, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL View

Earlier, I have written an article about SQL SERVER – Index Created on View not Used Often – Observation of the View. I received an email from one of the readers, asking if there would no problems when we create the Index on the base table. Well, we need to…

SQL SERVER – Public Training and Private Training – Differences and Similarities – Public Training vs Private Training

December 22, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Training

Earlier this year, I was on Road SQL Server Seminars. I did many SQL Server Performance Trainings and SQL Server Performance Consultations throughout the year but I feel the most rewarding exercise is always the one when instructor learns something from students, too. I was just talking to my wife, Nupur –…

SQL SERVER – Index Created on View not Used Often – Observation of the View

December 21, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL View

I always enjoy writing about concepts on Views. Views are frequently used concepts, and so it’s not surprising that I have seen so many misconceptions about this subject. To clear such misconceptions, I have previously written the article SQL SERVER – The Limitations of the Views – Eleven and more….…

SQL SERVER – Server Side Paging in SQL Server 2012 Performance Comparison

December 16, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Earlier, I have written about SQL SERVER – Server Side Paging in SQL Server 2012 – A Better Alternative. I got many emails asking for performance analysis of paging. Here is the quick analysis of it. The real challenge of paging is all the unnecessary IO reads from the database.…

SQL SERVER – Server Side Paging in SQL Server 2012 – A Better Alternative

December 15, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

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…

SQL SERVER – What is Page Life Expectancy (PLE) Counter

December 13, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

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]…