Jeff Moden

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

SQLServerCentral Article

GENERATE_SERIES() Breaks Minimal Logging

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

5 (9)

You rated this post out of 5. Change rating

2023-09-18

3,266 reads

SQLServerCentral Article

Combine DATE and TIME to DATETIME2 in SQL Server

The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".

5 (4)

You rated this post out of 5. Change rating

2023-08-07

6,126 reads

SQLServerCentral Article

4.9 (10)

You rated this post out of 5. Change rating

2022-07-13

17,683 reads

SQLServerCentral Article

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.35 (17)

You rated this post out of 5. Change rating

2021-05-28 (first published: )

9,685 reads

Technical Article

Create a Tally Function (fnTally)

Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.

4.86 (7)

You rated this post out of 5. Change rating

2019-08-13 (first published: )

5,527 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2019-08-08

6,034 reads

Blogs

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Read the latest Blogs

Forums

kopen valse paspoort (Telegram:+31637257997), rijbewijs,

By asuar1456

kopen valse paspoort (Telegram:+31637257997), rijbewijs, id kaart VISA, GROENE KAART, DIPLOMA'S Wij zijn de...

Comprar pasaporte falso (Telegrama:+34691183638)

By asuar1456

Somos los mejores productores de documentos de calidad , con más de 12 millones...

Comprar pasaporte falso (Telegrama:+34691183638), licencia de

By asuar1456

Comprar dni falso (Telegrama:+34691183638), licencia de conducir, pasaporte VISAS, TARJETA VERDE, DIPLOMAS Comprar dni...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers