Track source dates when loading a data warehouse
A primer on how to reduce network and source system load when reading a relational source into the data warehouse.
2012-07-30
5,032 reads
Magarity Kerns
HASHBYTES can help quickly load a Data Warehouse
Data warehouse loads can be time consuming - this method can be used in some instances to help speed things up.
2010-04-14
16,472 reads
Blogs
Experimenting with RedisGraph on Docker and Windows
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
Resources for Adding Graph Structures to Your Database at VS Live
By Steve Jones
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...
Resources for Architecting Zero Downtime Deployments
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Forums
Best way to ETL on large tablle with columnstore index
I have a table with 489M rows and growing. The reason we had to...
Unable To Create Transactional Replication - Microsoft SQL Error 20026
Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...
Grouping the first letter in a string
Hi All, I have the column of data in SQL Server. Here I need...
Ask SSC