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.