Jeff Moden

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

How much will it cost or save to rebuild that index? (SQL Oolie)

What's the true and permanent cost of lowering the Fill Factor of an index in SQL Server? It's a lot more than many people think. 9 year SQL Server MVP veteran, Jeff Moden, demonstrates how to calculate the extra space that will be used by lowering the Fill Factor and saved by increasing it.

4.27 (15)

2021-05-28 (first published: )

8,559 reads

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

5 (9)

2019-08-08

5,413 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)

2015-10-23 (first published: )

25,629 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 (61)

2014-09-19 (first published: )

29,602 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)

2014-06-24 (first published: )

23,866 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

Excel privary levels

By vismanto

There are three Excel privacy levels: Private, Organizational, Public. When Excel's privacy level is...

SSRS Migration Question

By CiyonAart

So I have a SQL 2017 server that has the two Report Server Databases,...

What is the specific job of the SQL Developer position?

By AllanLloyd

I knew about the position of SQL Developer through an introductory newspaper. I found...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers