t-sql programming

SQLServerCentral Article

GENERATE_SERIES() Breaks Minimal Logging

  • Article

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

5 (9)

You rated this post out of 5. Change rating

2023-09-18

3,835 reads

External Article

Ordered Columnstore Indexes in SQL Server 2022

  • Article

One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is not enforced by any SQL Server process. This leaves managing data order to us, which may or may not be an easy task.

2023-08-09

Blogs

Do Yourself a Favor, Check Out Woodler

By

I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love...

Vertically scaling SQL Server online in Kubernetes

By

One of the new features in Kubernetes v1.33 is the ability to resize CPU...

Stack Overflow & AI

By

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...

Read the latest Blogs

Forums

What’s the Difference Between AWS RDS and DynamoDB?

By pratikhole

When comparing AWS RDS and DynamoDB, the core difference lies in structure and use...

Analyzing Tempdb Spills and Usage Across Recursive Queries

By shukla.chandan12

Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...

Creating a new API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new API in...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers