CHARINDEX and PATINDEX both return the start position of a pattern in a text field. PATINDEX allows wildcards, CHARINDEX does not. Examples use AdventureWorks.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
CHOOSE: Handle Indexes Outside the List
CHOOSE returns an item from a positional list. Check unsupported indexes and compare a consistently typed CASE expression with an explicit fallback.
SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
Msg 7391 has no single fix. I list the causes I have hit on my servers, from distributed transactions on linked servers to DTC firewall settings, to try one by one.
SQL SERVER – Performance Optimization of SQL Query and FileGroups
My tips on transaction log placement, FileGroups for tables and non-clustered indexes, database size and autogrow settings for better SQL Server performance.
SQL SERVER – Fix: HResult 0x274D, SQLCMD Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired
SQLCMD error HResult 0x274D, Microsoft SQL Native Client: Login timeout expired? TCP/IP is off by default in SQL Server 2005; enable it in Configuration Manager.
SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
I compared a SQL Server 2005 paging query using ROW_NUMBER() with the SQL 2000 way of paging through temp or derived tables, both run on AdventureWorks.
SQL SERVER – 2005 – Performance Dashboard Reports
SQL Server 2005 Performance Dashboard Reports show CPU, IO, blocking and missing index problems as they happen. How to set them up and read them well.
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.