Silent truncation can happen while SQL Server evaluates a bounded expression. These examples compare the lost characters with a max expression and a max REPLICATE input. Check stored lengths before blaming a clipped display.
Low Memory Signals in the Resource Monitor Ring Buffer
Read the resource monitor ring buffer alongside Windows and process memory signals to investigate cache shrinkage in SQL Server.
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
CHARINDEX and PATINDEX both return the start position of a pattern in a text field. PATINDEX allows wildcards, CHARINDEX does not. Examples use AdventureWorks.
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: 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 – TempDB is Full. Move TempDB from one drive to another drive.
When TempDB is Full, I investigate capacity and usage before moving its files. A move requires a planned restart.
SQL SERVER – Index Seek Vs. Index Scan (Table Scan)
Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table.