Herman van Midden


SQLServerCentral Article

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.

(15)

You rated this post out of 5. Change rating

2013-08-19

10,228 reads

Blogs

SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026

By

SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...

Take Time to Gain Perspective

By

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

By

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Magelang Telp:08217555651

By layanan_Bca88

Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang,...

Alamat Kantor BCA KCU KUDUS Telp:08217555651

By m4rt1n4

Hub Via Wa:628217555651 Alamat Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus,...

Alamat Kantor BCA KCU Gang Tengah Telp:08217555651

By R4nt4u

Hub Via Wa:628217555651 Alamat Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa...

Visit the forum

Question of the Day

Database Mail Configuration

If I want to get a list of the configuration settings for Database Mail using T-SQL,  how can I do so?

See possible answers