SQL Server Magazine

Live Chat with SQL Server Magazine’s Authors

Join a live chat with SQL Server Magazine’s authors Andy Kelly, Mike Otey and Itzik Ben-Gan.

Calculate Percentiles

Use T-SQL to implement statistical calculations such as percentile and percentile rank.

Normalizing HIERARCHYID Values

Itzik explains how you can normalize or shorten HIERARCHYID values that became too long.

Microsoft SQL Server 2008: T-SQL Fundamentals Book

Itzik talks about his new T-SQL Fundamentals book that was just published.

Query Temporal Data

Learn how to handle temporal data in SQL Server queries despite limited support.

Solutions to T-SQL Sorting Challenge

Itzik provides solutions to last week’s T-SQL sorting challenge.

T-SQL Sorting Challenge

Itzik provides a T-SQL challenge involving sorting separated lists of values.

SQL Server 2008 RTM MERGE Bug and Fix

Itzik describes a bug involving the MERGE statement in SQL Server 2008 RTM, and provides a pointer to the bug fix.

Discover the Benefits of Filtered Indexes and Statistics

Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.

Equilateral Triangles Puzzle Solutions

Itzik provides solutions to the equilateral triangles puzzle.

SQL Server 2008’s HierarchyID, Part 2

Use the new HIERARCHYID data type to move a subtree from one parent location in the hierarchy to another, and to convert a parent-child representation of the hierarchy to a representation that uses the HIERARCHYID data type.

Equilateral Triangles Puzzle

Itzik provides a puzzle involving equilateral triangles.

Bug with NEWID Function

Itzik describes a bug involving the NEWID function and table expressions.

Into the Wild

Itzik talks about his impressions of Into the Wild—a book now made into a movie.

HierarchyID

Use SQL Server 2008’s new data type to maintain and query hierarchical data.

The Logical Puzzle

Get the solution to June’s puzzle, “Josephus Problem.”

HierarchyID

Solution to Shipping Algebra Puzzle

Itzik describes the solution to last week’s puzzle.

Shipping Algebra

See if you can solve this logic puzzle involving shipping and algebra.

Use T-SQL to Solve the Classic Eight Queens Puzzle

Hone both your logic and programming skills by using T-SQL to solve this logic puzzle.