Articles

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.36 (14)

2021-05-28 (first published: )

8,195 reads

Reading and Writing your Database's Documentation using JSON

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I'm doing for Redgate's Product Learning, I've been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object […]

2021-05-28

151 reads

Blogs

P2 Puts Easy, Flexible Project Tracking Tools In Your Hands

By

Improve your team's workflow and productivity with these project tracking blocks.

Daily Coping 22 Jun 2021

By

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

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Read the latest Blogs

Forums

Adding Comma , after IIF

By niteowl

So guys, I want the output value be like Opening Date, Closing Date Lets...

Handling OLEDB waits.

By JasonO

I have an application which runs on SQL 2016 & has a link server...

Finding the Group

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding the Group

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers