SQL Server

External Article

GENERATE_SERIES: My new go-to to build sets

  • Article

I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data set such as a numbers or calendar table. A few favorites include building sample data, pivoting an unknown number of columns, data extrapolation, and filling gaps in date or time ranges.

2023-07-26

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...

Monday Monitor Tips: Searching Permission Changes

By

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

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