UDF_ReverseString returns a reversed string starting from any position you pass. The script of the function plus usage examples, like reversing from the third character.
SQL SERVER – Copy Column Headers in Query Analyzers in Result Set
To copy column headers with your results in Query Analyzer, set Results to Text, Tab Delimited and turn on Print column headers in Options. Video included.
SQLAuthority.com 100th Post – Gratitude Note to Readers
A thank you note on the 100th post of SQLAuthority.com, to my readers for their emails, comments and support, and to my parents for their love.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.
SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1
Msg 3159 says the tail of the log was not backed up, then Msg 3013 ends RESTORE DATABASE. A script that worked in SQL Server 2000 failed in 2005, and here is why.
SQL SERVER – SET ROWCOUNT and TOP Precedence with Deterministic Limits
SET ROWCOUNT limits the session, while TOP limits a statement. I reset ROWCOUNT after testing so later queries keep their intended limits.
STRING_SPLIT Ordinals: Order the Rows You Read
STRING_SPLIT ordinals preserve a token position for SQL Server 2022 and later. This example keeps duplicate tokens, exposes an empty token and orders the returned rows explicitly.
SQL SERVER – Random Number Generator Script – SQL Query
A random number generator in SQL Server needs the correct range and evaluation scope. These tested scripts cover integer bounds, repeatable seeds, per-row values, and common overflow mistakes.
SQL SERVER – Replication Keywords Explanation and Basic Terms
A quick reference of Replication keywords I wrote for Jr. DBAs: publisher, subscriber, distributor, publication and article, each explained in plain words.
SQL SERVER – Explanation SQL SERVER Merge Join
What a Merge Join needs and when it is fast: two sorted inputs with matching column types. Presorted B-tree indexes make it quick, extra sorts make it costly.