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 – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query
SET ROWCOUNT limits how many rows a query returns, and SQL Server stops once it has them. See the syntax, how SET ROWCOUNT 0 resets it, and when it is ignored.
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 – 2005 Security DataSheet
The SQL Server 2005 Security DataSheet from Microsoft covers its security features, like automatic secured updates and encryption of sensitive data.
SQL SERVER – Random Number Generator Script – SQL Query
Random Number Generator. There are many methods to generate random numbers in SQL Server.
Method 1: Generate Random Numbers (Int) between Rang
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.