Jeff Moden

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

SQLServerCentral Article

4.88 (8)

2022-07-13

2,596 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.27 (15)

2021-05-28 (first published: )

9,091 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)

2019-08-08

5,738 reads

Blogs

Visiting with DBAs at midnight : T-SQL Tuesday #153

By

🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...

Working with Neo4j Imports–I HATE CASE SENSITIVITY

By

I’ve been working to better understand graph databases and where they can be useful....

Daily Coping 8 Aug 2022

By

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

Read the latest Blogs

Forums

MAX not working with a CTE

By DaveBriCam

I have a query that is supposed to return one patient id but even...

doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'

By RazLinky

i have a cursor that runs on all my views   and then exec...

Transaction log full error 9002 on Alwayon Availability groups

By vsamantha35

Hi All, I am looking for some inputs on how to avoid or prevent...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers