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

Measuring and Improving SQL Server Query Plan Cache Efficiency

By

Measuring and Improving SQL Server Query Plan Cache Efficiency The query...

Communicate to the Individual

By

I may think I'm trying to reach the crowd, but I'm really trying to...

PESTLE Analysis for Databases Explained | Real-World Use Cases & Tool

By

📘 Understanding PESTLE PESTLE is a strategic framework used to evaluate external macro-environmental factors...

Read the latest Blogs

Forums

The Technical Debt Anchor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Technical Debt Anchor

Getting the Updated Column List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Updated Column List

SSRS: An error occurred during local report processing. The definition of ...

By sgmunson

Here's the complete error: An error occurred during local report processing. The definition of...

Visit the forum

Question of the Day

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()

See possible answers