Les Smith

I am a database developer working with SQL Server and Oracle8i. My focus is on data warehousing, reporting and analysis. The tools I use are Java, Stored Procedures, Visual Basic and commercial applications such as Informatica. I am currently working at an Application Service Provider company in Silicon Valley.

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2001-08-27

3,254 reads

Blogs

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs

Forums

Scaling Up Monitoring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Scaling Up Monitoring

Database Sequence Objects with dbatools

By Mikey Bronowski

Comments posted to this topic are about the item Database Sequence Objects with dbatools

Why a monitoring tool is an essential tool for growing server estates

By Site Owners

Comments posted to this topic are about the item Why a monitoring tool is...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers