Index

External Article

Hands-On with Columnstore Indexes: Part 1 Architecture

  • Article

Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be wondering why they are different than traditional indexes and how they work. In this series, Edward Pollack explains the architecture of Columnstore indexes. In future articles in the series, he will describe best practices for Columnstore.

2020-06-18

SQLServerCentral Article

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

You rated this post out of 5. Change rating

2019-08-08

6,194 reads

Blogs

Learning Database Design and Power BI Performance

By

I spend my days working on and managing SQL Server instances—working days at least,...

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Monday Monitor Tips: CIS Compliant

By

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...

Read the latest Blogs

Forums

Generative AI Services and the Future of Content Moderation Jobs

By inbathiru

Introduction to Generative AI Services Welcome to the cutting-edge world of Generative AI Services,...

need help with assigning a value to a variable

By water490

Hi I am trying to assign the value of the  variable using the output...

Merry Christmas 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Merry Christmas 2025

Visit the forum

Question of the Day

The Reindeer Count

How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.

See possible answers