Life as a SQL Swiss Army Knife

..or maybe I'm just the guy with the shovel behind the horses in the parade
posts - 5, comments - 0, trackbacks - 0

September 2010 Blog Posts

How to tell what your insert, update is doing

Lately I’ve been working on a data migration SSIS package for a customer and some of it is just a straight forward execute sql tasks in SSIS on some very large tables. I pull 10 million rows into a staging area, massage some data into the proper format, insert it into it’s final production table resting place, easy enough. I’m testing it on a very low powered 32 bit server and it takes a while. At one point today I started wondering if it was just locked up or was still running. I’ve used the sys.partitions table before...

posted @ Thursday, September 02, 2010 8:15 PM | Feedback (0) |

Powered by:
Powered By Subtext Powered By ASP.NET