This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
EDIT_DISTANCE and JARO_WINKLER: Fuzzy String Matching in SQL Server 2025
EDIT_DISTANCE counts the single-character changes between two strings, and the JARO_WINKLER functions score how alike they look. This post tests the four preview functions on SQL Server 2025, shows the Windows collation error and its fix, and finds near-duplicate customer names.
Excel – Sum vs SubTotal – SQL in Sixty Seconds #167
Just like SQL Server, I work with MySQL, PostgreSQL, MariaDB, MongoDB, and Excel. Today we are going to see in excel which is about Sum vs SubTotal.
3 Ways to Configure MAXDOP – SQL in Sixty Seconds #166
We will see a quick SQL in Sixty Seconds video and scripts used in the video to change MAXDOP. Let us watch 3 Ways to Configure MAXDOP.
Get Memory Details – SQL in Sixty Seconds #165
My blog post SQL SERVER – 3 Queries to Detect Memory Issues. Lots of people wanted me to create a video on this topic – get memory details.
SQL SERVER – 3 Queries to Detect Memory Issues
One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
DBCC CHECKIDENT: Check and Fix the Next Identity Value
DBCC CHECKIDENT reports the next identity value of a table and can change it. This post runs NORESEED, the no-option form and RESEED on a small demo table. It shows how DELETE and TRUNCATE treat the counter, the duplicate key error from a value that is too low, and who may run the command.