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

2019-09-17

5,588 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

4,376 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

How to make group by Revision_ID and when repeated display last check date separ

By ahmed_elbarbary.2010

problem How to make group by Revision_ID and when repeated display last check date...

buy medical weed online

By rondavis544

Very important Health information that might help you or some one you know,((www.legalweedonlinestore.com/)) the...

wholesale hemp buds uk

By rondavis544

Treasure valley farm is a B2B company. Our bulk top class CBD hemp flower...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers