Les Smith

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

2001-08-27

3,139 reads

Blogs

How I passed the 70-761 certification exam

By

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Read the latest Blogs

Forums

What Write Ahead Logging Is and Why It Matters

By Kendra Little

Comments posted to this topic are about the item What Write Ahead Logging Is...

SSAS Error: Duplicate attribute key found when processing

By aveek22

Comments posted to this topic are about the item SSAS Error: Duplicate attribute key...

Using Calendars and Dates in Power BI

By Additional Articles

Comments posted to this topic are about the item Using Calendars and Dates in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers