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
3,764 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
15,030 reads
Source system pre-integration analysis
Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, […]
2005-06-07
436 reads
Blogs
Azure SQL Database – Azure Portal Updates
By Arun Sirpal
A small but useful change has been made to the Azure Portal for Data...
SQL Server Quick Tips
By Bert Wagner
Earlier this year I made a series of videos that were played before the...
The 2019 State of DevOps Report–Webinar
By Steve Jones
Tomorrow I get to chat with another giant in the world of DevOps: Jez...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Tsql/SP Code Optimization
Hi, I am working on optimizing some of Tsql code for SP's. I know...
Ask SSC