TAN reads radians and returns float. These safe angles demonstrate sign and magnitude while explaining why a large finite float near ninety degrees is not a meaningful infinity.
SQL SERVER – SQL Slammer (Computer Worm)
Is there any virus associated with SQL Server? A DBA’s question led me to SQL Slammer, the computer worm that slowed down Internet traffic in January 2003.
PATINDEX and CHARINDEX: Pattern or Literal Search
PATINDEX and CHARINDEX answer different questions. Compare wildcard patterns with literal searches, preserve NULL, and pin collation for digit ranges.
Reading the Warnings in an Execution Plan
Warnings in an execution plan can reveal conversions, missing statistics, and spills; read each warning in workload context.
SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2
Reader jwwishart shared another way to find database collation in SQL Server 2005: a one line SELECT of collation_name from sys.databases.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2
A last resort for corrupt datafiles with no backup: emergency mode, single user, then DBCC CHECKDB with repair_allow_data_loss. Back up the files first.
SQL SERVER – 2005 – Connection Strings For .NET
SQL Server 2005 connection strings for .NET, ODBC and OLE DB with SQL Native Client: standard security, trusted connection and named instance examples.