Blog Home Page - Page 428 of 831 - SQL Authority with Pinal Dave

Mar24

I just had an interesting conversation the day before when I was discussing about Join Order in one of my recent presentations. The comment which triggered all the conversation was “If I want to change the order of how tables are joined in SQL Server, I prefer to use CTE…

Mar23

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

No Comments

This may be surprising to many, but I have seen quite a few times so far so decided to blog over here. Here is the sequence of the action: The developer turns on Graphical Execution plan for any query with CTRL+M Now turns on the execution plan in the text…

Mar22

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Professional Development, Software Development

No Comments

I was just reading Dr. W. Edwards Demings 14 principles of Total Quality Management. It is indeed very impressive and interesting. I have tried to collect a few of the important resources related to the same over here. Dr. Demings’s 14 principles Create a constant purpose toward improvement Adopt the…

Mar21

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

MySQL has an inbuilt function called FIND_IN_SET which will search for values within a comma separated values. It basically returns the index position of the first parameter within the second parameter. This can be alternatively used to replace the IN clause. Let us create the following tables CREATE TABLE items(item_id…

Mar20

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

Pinal Dave

SQL

Notes from the Field, SQL Index, SQL Server

[Notes from Pinal]: Indexes are considered as a silver bullet for performance tuning and do amazing job when they are properly created. Just like any other engine they need maintenance and tuning. As we get more data, indexes start to get fragmented and performance starts to degrade. I asked direct questions to my friend Tim about index fragmentation and he gave me a very interesting answer.

Mar19

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

Some conversations are very interesting and I would like to bring them to everyone’s attention. Here is one of the conversation happened earlier this week. Let us say the question was asked by Dustin. Dustin: Can we retrieve last 10 rows from a table? Pinal: Sure, just get the top…

Mar18

SQL SERVER – Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Safepeak

We’ve all been reading a lot of articles that suggest adding a caching layer in front of a database is more efficient than hitting the database directly. Among different caching options there is Do-It-Yourself coding, using open source tools like Memcached, or using Velocity (part of the Microsoft AppFabric) or…

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

SQL SERVER - Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak indexfinger

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

SQL SERVER – Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

SQL SERVER – Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak

SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

SQL SERVER – Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak