Blog Home Page - Page 427 of 829 - SQL Authority with Pinal Dave

Mar21

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…

Mar17

MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports pattern matching comparison using regular expressions with REGEXP keyword. In this post we will see how to use REGEXP in MySQL. We can use the patterns ^, $, | and sqaure braces to effectively match the values. Let us create the following table: CREATE TABLE items(item_id INT, item_description…

Mar16

SQL SERVER – What is the Difference Between Latches and Locks

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

A very common question I often get in the email is “What is the difference between latches and locks?” The answer to this question is not an easy one. Here is a quick answer from the MS white paper. A page in SQL Server is 8KB and can store multiple…

Mar15

SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL Stored Procedure

Here is one of the very common interview questions I often ask people – Q: What is the default Port SQL Server running on? A: 1433 for TCP/IP and 1434 for USD connection. I always get the correct answer for this question. However, when I ask a follow up question,…

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014

SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072

SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042

SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 100 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.

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.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

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

MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP

SQL SERVER – What is the Difference Between Latches and Locks

SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running

SQL SERVER – Convert Old Syntax of RAISEERROR to THROW

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014

SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072

SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042

SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation