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,575 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,068 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
438 reads
Blogs
STRING_SPLIT Basics–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
Forums
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
SQL Server Kerberos authentication from a Linux clients
Hi All, I have a need to establish a SQL Server Kerberos authentication from...
Housekeeping of SQL Azure DB's
Hi all, I have a question for you, as some move into the cloud...
Ask SSC