Guest Columnist: Jeff Moden

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...

There are many methods to do Running Totals and most are either slow to terribly slow or just unreliable. Here's the right way to do very high speed Running Totals.   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...