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
4,403 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,897 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
437 reads
Blogs
Data Saturday #8–Southwest US
By Angela-Henry
I am very excited to announce that I will be speaking for Data Saturday...
Data Weekender v3.1
By Angela-Henry
I am super excited about this new version of Data Weekender, coming up on...
Thanks Kathi and Mala
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
SQL 2016 - Need help with complex calculations based on paycodes - New Changes
Hello Friends, Posting this for help as the client made more requirement changes. I...
Daily Autocheck for SQL instances
[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders The above code is not returning all...
Ask SSC