Indexing

“Included columns” for non-clustered indexes explained

  • Article

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]

4 (5)

2019-09-17

4,349 reads

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

  • Article

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

2019-09-03

3,751 reads

A Self-Tuning Fill Factor Technique for SQL Server – Part 2

  • Article

Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexes within a database. Part 2 covers an analysis of the data collection […]

5 (2)

2019-08-27

2,483 reads

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

  • Article

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

4,500 reads

Blogs

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Will the principal wait for acknowledgement from mirror?

By coolchaitu

Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....

The log file of my user db is full. Please confirm if below resolves issue

By coolchaitu

Good morning experts, The log file of my user db is full. Could you...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers