Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

SQLServerCentral Editorial

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.

3.14 (7)

You rated this post out of 5. Change rating

2017-08-11 (first published: )

713 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2015-10-23 (first published: )

33,146 reads

SQLServerCentral Article

Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.

4.84 (50)

You rated this post out of 5. Change rating

2015-04-03 (first published: )

54,909 reads

SQLServerCentral Article

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 (62)

You rated this post out of 5. Change rating

2014-09-19 (first published: )

35,536 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2014-06-24 (first published: )

25,287 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2014-01-23

19,262 reads

Blogs

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks

By

I’ve been using Azure SQL Database for quite some while and have set up...

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

Read the latest Blogs

Forums

Build a Better WordPress Archives Page Using MySQL

By Site Owners

Comments posted to this topic are about the item Build a Better WordPress Archives...

Max Managed Instance CPUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Max Managed Instance CPUs

Analyze Data with a Serverless SQL pool in Azure Synapse Analytics

By arindamxs

Comments posted to this topic are about the item Analyze Data with a Serverless...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers