How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.

The Lesser Used Functions

There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?

SQL Server OPTION RECOMPILE for Simple Queries

Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.

How to Attach and Detach Databases in SQL Server

Learn how to effectively attach and detach databases in SQL Server, exploring the differences between these methods and traditional backup and restore procedures. Streamline your database management tasks with clear, step-by-step instructions.

The Funny Dynamic SQL

Why a Self-Join Requires Halloween Protection

I was asked recently why Halloween Protection was needed for data modification statements that include a self-join of the target table. This gives me a chance to explain, while also covering some interesting product bug history from the SQL Server 7 and 2000 days.

Function Defaults

The Random Rows

Getting ANY of the data

Subqueries II