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

766 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

701 reads

It is Friday, the queries are running, and nobody is watching the bill. That...

Annabel retired from Redgate Software this week. Across most of my career at Redgate,...

As a SQL Server DBA with years of experience tuning production environments, I’ve seen...

WhatsApp:0818-751-777 Jl. M.T. Haryono No.68, Tengah, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78812...

WhatsApp:0818-751-777 Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa...

WhatsApp:0818-751-777 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212 (@bcakcpbrebes)

When running bcp on Linux, what is the field terminator?