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,198 reads

Blogs

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

SQL Server 2025

By

Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...

Advice I Like: Apologies

By

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Read the latest Blogs

Forums

Influencing a Local AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Influencing a Local AI

Data API Builder Operations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data API Builder Operations

SQL Clustered Resource in online pending for about 3-5 mins before coming online

By PJ_SQL

Hello! SQL Clustered resource used to come online during manual or automatic failover in...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers