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,752 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,456 reads

Blogs

ACM Lecture at SELU

By

Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Removing ad hoc plans from Query Store

By

This is not a post about the “optimize for ad hoc workloads” setting on...

Read the latest Blogs

Forums

Optimize Cursor

By GrassHopper

I inherited this script that has a cursor and I know this query can...

Unable to add secondary node existing node due to DCOM is unavaialble

By maroju1

Dear Team, This is Naveen, Hope all are doing well. I need emergency help...

To show the count per month from the date provided

By VSSGeorge

I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers