SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Guest Columnist: Jeff Moden

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

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...
By Jeff Moden 2008/05/22 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 4 reads

The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

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...
By Jeff Moden 2008/05/07 | Source: SQLServerCentral.com | Category: TSQL
Rating: |  Discuss |  Briefcase | 9,443 reads

More RBAR and "Tuning" UPDATEs

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...
By Jeff Moden 2008/03/14 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 6,056 reads

Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

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...
By Jeff Moden 2008/01/31 | Source: SQLServerCentral.com | Category: Advanced Querying
Rating: |  Discuss |  Briefcase | 4,104 reads

Performance Tuning: Concatenation Functions and Some Tuning Myths

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...
By Jeff Moden 2008/01/01 | Source: SQLServerCentral.com | Category: Test Data
Rating: |  Discuss |  Briefcase | 7,327 reads

Hidden RBAR: Triangular Joins

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...
By Jeff Moden 2007/12/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 11,931 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2007/11/27 | Source: SQLServerCentral.com | Category: Best Practices
Rating: |  Discuss |  Briefcase | 5,219 reads

Calculating Work Days

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...
By Jeff Moden 2007/09/07 (first posted: 2005/01/10) | Source: SQLServerCentral.com | Category: Advanced Querying
Rating: |  Discuss |  Briefcase | 30,879 reads
   Items 1 to 8 of 8