Aggregating Correlated Sub-Queries

Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:

Display row value as a TABLE column using SQL select statement

Display row value as a TABLE column using SQL select statement

Combining Rows

Truncate Table

Working with Time Spans and Durations in SQL Server

What is the best way to return the "duration" of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios?

A New (and Hopefully Better) Approach to Constants

A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.

Quick table finder

This little script will search for all matching tables on the SQL Server instance

How to empty database

Sometimes you need to empty the content of database. Following script can do that for you.

Function to Expand Tab Characters

A function to replace tab characters with the correct number of spaces to align the text as originally intended.

Collation Error 468

Most DBAs don't ever deal with multiple languages or different collation and sort order settings in SQL Server, but it can be a handy piece of information to have. Steve Jones brings us a quick look at a problem in comparing data across databases.