Indexes

How Bad are Bad Page Splits – The Rest of the Story

  • Article

In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]

4 (3)

2020-07-02

3,788 reads

“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

7,725 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

5,146 reads

Blogs

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Two methods of deployment Azure Data Factory

By

Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...

Read the latest Blogs

Forums

Interview question about CPU

By Lord Slaagh

Hello SSC friends, I am a SQL Developer who is learning how to be...

Who is my customer?

By Kathi Kellenberger

Comments posted to this topic are about the item Who is my customer?

Newbie; Unsure where to Start?

By ptmuldoon

Hi,  First time poster, and hoping everyone goes easy on me. I am very...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers