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

You rated this post out of 5. Change rating

2023-09-18

2,835 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 (3)

You rated this post out of 5. Change rating

2023-08-07

3,996 reads

SQLServerCentral Article

4.9 (10)

You rated this post out of 5. Change rating

2022-07-13

15,367 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,629 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,382 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

5,993 reads

Blogs

SQL Saturday Denver 2023–VCS Primer for the Database slides

By

My slides are here: VCS Primer Denver 2023 This was an overview of what...

Future Data Driven 2023 is This Week

By

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Read the latest Blogs

Forums

Hello i am new to Sql and idk why i get this error and also not getting results.

By imon

CREATE DATABASE dbsubjects; CREATE TABLE tblstudent( ID INTEGER PRIMARY KEY, TheName Varchar (100), TheAddress...

Identifying the process that is backing the databases to virtual device

By ramana3327

We have about 20 SQL Servers. We use Net backup or Native backup for...

SQL Migration - Identifying Connections - Best approach

By ramana3327

I have one SQL Database server which is old version and planning to migrate...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers