Grouping with SQL Server 2008

Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.

SQL Techniques for Performing Operations on Matrices

SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.

Use Excel to DIFF Your Query Outputs

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.

Triggers

SQL inner and outer joins: Basics for getting started

Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.

Query Hints

CURRENT_TIMESTAMP

Power and Deception of CTEs

A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world

Table Variables

TSQL