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

740 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

674 reads

While I always configure transaction log backups for every database in non-simple recovery model,...

There’s a video of Bill Gates taking a drive in an autonomous car around...

It is common to see high worker count issue on the production server and...

I want to align a Date column (datetime2(7)) with the same full resolution date...

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...

Looking for suggestions\examples of how to update a SP that the table used changes...