Jeff Moden

Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.

4.78 (27)

Jeff Moden

2014-01-23

6,128 reads

A Simple Formula to Calculate the ISO Week Number

He admits it wasn’t his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you’re "stuck" with SQL Server 2005 or less, you’re going to like this a whole lot!

4.89 (36)

Jeff Moden

2015-10-23 (first published: 2013-04-08)

12,932 reads

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?

4.92 (26)

Jeff Moden

2012-11-15

9,896 reads

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".

4.9 (60)

Jeff Moden

2014-09-19 (first published: 2012-11-13)

19,361 reads

How to Make Scalar UDFs Run Faster (SQL Spackle)

It’s a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.

4.93 (102)

Jeff Moden

2014-06-24 (first published: 2012-08-01)

18,585 reads

Blogs

CISA Accredited Trainer!

By Brian Kelley

My certification came in! I’m now accredited to provide training for the Certified Information...

Correlated Subqueries vs Derived Tables

By Bert Wagner

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...

Video – Creating Azure SQL Database

By Arun Sirpal

A quick 2 minute upload (with sound, my voice) showing you how easy it...

Read the latest Blogs

Forums

dput()

By Steve Jones - SSC Editor

Comments posted to this topic are about the item dput()

Can Azure Stack Reduce Software Development Costs?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can Azure Stack Reduce Software...

Splitting a multi-dimensional Array in SQL Server 2012

By Slady

Hello, I have data from an Orders table has the following columns; OrderId (int)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

dput()

See possible answers