Also on the subject of checksum testing, this query will generate a checksum query for a given table. Use this query to generate the checksum for each table, then customize the sum() clauses if you did any transformations on your data.
select case a.xtype
when 167 then ‘SUM(LEN(‘+a.name+’)) as sum_len_’+a.name+’,’
when 175 then ‘SUM(LEN(‘+a.name+’)) as sum_len_’+a.name+’,’
when 231 then [...]
select upper(b.name) as table_name, upper(a.name) as column_name,
a.colid, a.length, a.xprec, a.xscale, a.xtype,(CASE WHEN a.xtype=167 then ‘varchar’
WHEN a.xtype=175 then ‘char’
WHEN a.xtype=61 then ‘datetime’
WHEN a.xtype=106 then ‘decimal’
END) as col_type
from syscolumns a,
[...]
Here is a useful query for getting a list of failed jobs from SQL
Server. If you are responsible for tracking and logging job failures, this administrative work can be overwhelming in a busy week. This query will list all jobs that
failed during a given time period. It uses a function that I created,
convert_run_datetime.
<code>select a.name, [...]
Loading your target incrementally offers a huge performance benefit over running full truncate/reloads, but there is a danger of missing inserts or updates in your source system. It can take hours or days to track down the source of these problems (if it can be done at all!) and problems are generally not found until [...]
I don’t burn ISO images onto disk very often, but every time I do it seems like I spend an inordinate amount of time downloading, installing, and trying to use several utilities before I finally find one that works.
The search is over. ISO Recorder is free, fast, and easy to use. Dead easy. Thank [...]
Donald Farmer is blogging again! Donald works as Project Manager of the SQL Server Integration Services team at Microsoft. Donald is a very smart guy; gifted at explaining technology in an engaging and enjoyable way. One technique Donald uses is to heavily salt his speeches with good personal anecdotes. This quote aptly demonstrates why I [...]
I scan a handful of financial blogs pretty regularly. I also scan a handful of technical blogs relating to SQL Server and Oracle. It isn’t very often that a blog from one of these worlds links to a blog in the other. But here’s JLP from AllFinancialMatters linking to Don Burleson of oracle-dba.com fame. I [...]