LIKE with a leading wildcard reads the whole table. A small side table of words turns that scan into a quick lookup, and you do not need full-text installed.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Multi-Value Report Parameters in T-SQL Without Dynamic SQL
A report that sends 1, 2, 2, 3 does not need dynamic SQL. Here is how to split, validate and match the list safely.
SQL SERVER – Identify Columnstore Index Usage from Execution Plan
My two word Twitter reply was “From Operators,” so here is the full answer on how to spot columnstore index usage in the execution plan.
SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function
Can one table, used once, give 2 join operators in an execution plan? Readers used ranking functions, and my own answer relies on index intersection.
Reading Default Data and Log Paths With InstanceDefaultDataPath
Changing the default folder does not move a single existing file. Here is how to read the defaults and spot databases that ignore them.
SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani
Object names in SQL Server can be up to 128 characters, but local temp tables stop at 116. Guest author Balmukund Lakhani explains this limit for Temp Objects.
Designing a Simple ETL Framework
An ETL framework in SQL Server needs a small set of configuration, run logs, restart checkpoints, and alerts that operators can trust.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.