A quick look at the different types of cache objects SQL Server 2005 keeps in the procedure cache, from a troubleshooting book I reviewed.
SQL SERVER – Find Name of The SQL Server Instance
SELECT @@SERVERNAME returns the name of the SQL Server instance. We used it in stored procedures that ran different logic on each server during a migration.
LEN Versus DATALENGTH: Trailing Spaces and Unicode Bytes
LEN versus DATALENGTH answers different length questions. Use explicit text types to check trailing spaces, Unicode bytes, empty values and NULL.
SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS
@@CONNECTIONS and @@MAX_CONNECTIONS explained: login attempts since SQL Server started versus the most simultaneous user connections allowed.
SQL SERVER – Introduction and Example for DATEFORMAT Command
I found DATEFORMAT in a Jr. DBA’s code. SET DATEFORMAT sets the order of month, day and year so SQL Server can read date strings in other formats.
SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
Error 3154 says the backup set holds a backup of a database other than the existing database. Use WITH REPLACE in RESTORE, or drop the old database first.
THROW or RAISERROR
THROW or RAISERROR changes how SQL Server handles severity, formatting, and XACT_ABORT; choose the right pattern for new procedures.