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,149 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,553 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
439 reads
Blogs
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Friday Flyway Tips–Flyway Parameters
By Steve Jones
Flyway is a command line tool with lots of options and parameters. Working with...
Forums
table with varcahar(max)
Gurus, there is a table which is very slow to query , it has...
Query goes crazy.
Hi. I have a query that returns few rows (out of 7 table join,...
Migration from Sybase SAP SQL Anywhere to SQL Server 2022
By Stewart "Arturius" Campbell
We are working on a project to migrate a client from a version of...
Ask SSC