Guest Columnist: Jeff Moden

Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.  Read more...

Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method for replacing multiple spaces from MVP Jeff Moden.  Read more...

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.  Read more...

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.  Read more...

It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.  Read more...

Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.  Read more...

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...

Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.  Read more...

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...

Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.  Read more...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week. Monday through Friday. New author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.   Read more...