Full-Text Search Operators – Part 3: Splitting the search string
Part 3 of the Full-Text Search Operators series: splitting a search string into classified terms using CTEs in SQL Server.
Read more →Posts
Look where you want to go
A motorcycle riding lesson applied to SQL Server troubleshooting: avoid target fixation and look for alternative paths around stubborn problems.
Read more →
Full-Text Search Operators – Part 2: Replacing alternate operators
Part 2 of the T-SQL full-text search series, replacing alternate operator symbols like |, &, and - with normalized text placeholders.
Read more →
Removing accented and illegal characters from a string
A T-SQL function that strips illegal characters from strings and replaces accented letters with their plain equivalents for search cleanup.
Read more →
Full-Text Search Operators – Part 1: Cleaning up parentheses in a string
Part 1 of building a T-SQL Boolean search parser for SQL Server full-text search, covering parentheses validation and cleanup.
Read more →
Generate scripts to detach/attach all databases
A T-SQL script that generates sp_attach_db commands for all user databases with their file paths, simplifying detach and reattach operations.
Read more →
Do you want a job? Then don’t do this…
Common mistakes job applicants make when applying for database roles, from text-speak in applications to sending the wrong cover letter.
Read more →
Identifying unique indexes that aren’t defined as unique
A SQL Server script to find non-unique indexes where the underlying data is currently distinct, identifying candidates for unique index conversion.
Read more →
SQL Breakfast
How a team Tech Breakfast watching Kimberly Tripp's Indexing Internals session turned into a great way to learn and spark discussion.
Read more →
Our SQL Server “Denali” experiences – Part 2
Load testing SQL Server Denali at Trade Me with impressive results, handling 50% of search traffic and solving full-text performance issues from SQL 2008.
Read more →