Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Jeff Moden

SQLServerCentral.com profile

<< Newer    Items 21 to 33 of 33   
 

What's in your CLR?

For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.  Read more...
By Jeff Moden 2009/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 500 reads

Solving the Running Total and Ordinal Rank Problems (Rewritten)

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...
By Jeff Moden 2012/01/27 (first published: 2009/11/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 30,980 reads

REPLACE Multiple Spaces with One

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 from MVP Jeff Moden.  Read more...
By Jeff Moden 2012/08/17 (first published: 2009/11/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 43,104 reads

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

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...
By Jeff Moden 2010/04/30 (first published: 2008/12/03) | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 40,364 reads

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.  Read more...
By Jeff Moden 2010/08/06 (first published: 2008/08/19) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 93,537 reads

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 2010/01/08 (first published: 2008/05/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,763 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 2014/07/04 (first published: 2008/05/07) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 89,824 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 | 11,666 reads

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

Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.  Read more...
By Jeff Moden 2008/01/31 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 15,183 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 | 15,359 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 2009/01/16 (first published: 2007/12/06) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 50,930 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 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 113,226 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 published: 2005/01/10) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 42,898 reads
<< Newer    Items 21 to 33 of 33