Ziek's SQL Home

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...

2012-05-04

751 reads

Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.

There are...

2012-05-03

692 reads

One of the things I’ve tried hard to do in database development situations if...

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

This T-SQL Tuesday is hosted by the one and only James Serra – literally...

We have two "identical" instances of an ASP.NET web service (or so I have...

Comments posted to this topic are about the item OPENQUERY Flexibility

Comments posted to this topic are about the item A Full Shutdown

Which of these are valid OPENQUERY() uses?