Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video
SQL Index
Storing data non-contiguously on disk is known as fragmentation. Before learning to eliminate fragmentation, you should have a clear understanding of the types of fragmentation. When records are stored non-contiguously inside the page, then it is called internal fragmentation. When on disk, the physical storage of pages and extents is not contiguous. We…
Read More

SQL SERVER – Transcript of Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video
SQL Index
Recently I just wrote a blog post on about Learning SQL Server Performance: Indexing Basics and I received lots of request that if we can share some insight into the course. Here is 200 seconds interview of Vinod Kumar I took right after completing the course. We have few free codes to…
Read More

SQL SERVER – SQL Server Misconceptions and Resolution – A Practical Perspective – TechEd 2012 India

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks
TechEd, TechEdIn
TechEd India 2012 is just around the corner and I will be presenting there in two different sessions. On the very first day of this event, my presentation will be all about SQL Server Misconceptions and Resolution – A Practical Perspective. The dictionary tells us that a “misconception” means a view or…
Read More

SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Wait Stats, TechEd, TechEdIn
TechEd India 2012 is just around the corner and I will be presenting there on two different session. SQL Server Performance Tuning is a very challenging subject that requires expertise in Database Administration and Database Development. I always have enjoyed talking about SQL Server Performance tuning subject. Just like doctors I…
Read More

SQL Server – Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video
SQL Index
Recently I just wrote a blog post on about Learning SQL Server Performance: Indexing Basics and I received lots of request that if we can share some insight into the course. Every single time when Performance is discussed, Indexes are mentioned along with it. In recent times, data and application complexity is…
Read More

SQL Server – Learning SQL Server Performance: Indexing Basics – Video

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video
SQL Index
Today I remember one of my older cartoon years ago created for Indexing and Performance. Every single time when Performance is discussed, Indexes are mentioned along with it. In recent times, data and application complexity is continuously growing.  The demand for faster query response, performance, and scalability by organizations is…
Read More