Browsing the blog archives for October, 2009

INSERT to a table with an IDENTITY Column

I’ve been a SQL Practitioner since 1996 when 6.5 was the hot item.  Along the way I’ve learned a bunch of stuff about SQL Server.  Without a doubt, the more I learn, the more I know what I don’t know.  Being humbled on a regular basis is probably a good thing, but sometimes it’s just […]


Speed Up Startup of SQL Server Management Studio

Have you ever noticed how long it takes to start up SQL Server Management Studio (SSMS)?  I always assumed it was because it is the biggest and most powerful tool in my toy box and it deserves the load time. You can SIGNIFICANTLY reduce the load time by avoiding Microsoft’s marketing message at startup, the […]

Table Partitioning via the Clustered Index

Today’s post will demonstrate how to partition an existing table without disturbing the existing data in the table by taking advantage of it’s clustered index. SQL Server Books Online (BOL) is laced with interesting tidbits of information but sometimes falls short of delivering on the specifics.  Let’s face it, there’s no way to demonstrate every […]

7-Zip Output Argument

This is a real quickie but it cost me dearly this weekend.  My task was to call 7-zip from within SSIS and extract the contents. Here’s the basic example that’s all over the Internet: 7z e -oC:\Doc Where: 7z is the executable e is the argument to perform an extract is the file […]


Column DIFF between two tables

I recently had a situation where I needed to compare table columns between the production table and a test/development table.  Chances are if I needed to do it someone else will to. I like using the EXCEPT SET OPERATOR.  Some people might prefer to use an OUTER JOIN to determine the column differences.  With the […]

Use a View to Control the Size of UPDATE Transactions

In several of my production databases I have to deal with tables that have hundreds of millions of records.  Querying these tables are challenging; doing updates to them can be nightmarish. I recently had to add a column to a table that had 65 million records.  The table is an aggregate table so the new […]

Download a file from the web using SSIS

There are some tasks, no matter how seemingly simple, I just would not want to have to do again.  Today’s post is about one of them… At work we use a data cleansing tool that purchased from the USPS (Post Office) called NCOA (National Change of Address).  All of the big list brokers use the […]

1 Comment

Write Row Count to Flat File Using SSIS: Part III

This is the third and final part to this thread on how to capture the number of rows being processed in SSIS to a flat file. In Part I we learned how not to do it and why it didn’t work. In Part II we showed how to use the ROW COUNT transformation to populate […]

Write Row Count To Flat File Using SSIS: Part II

In yesterday’s post we pulled a Thomas Edison and showed one of 10,000 ways how not to write the number of records being processed using the ROW COUNT transformation. We thought the process was straight forward, but it didn’t work.  Our approach was: 1.  Create a query that processed some records. 2.  Send the result […]


Writing Row Count to Flat File in SSIS: Part I

Yesterday I had a simple enough task at hand.  An existing EXTRACT that loads a result set to a DATA file needed to have a corresponding COUNT flat file that contained the number of rows in the extract’s data file.  Not being the most savvy at SSIS I did what anyone else would do get […]


My Five Reasons for Blogging

My wife of 24 years recently asked me “Why blog?  Are you looking for a new job?” At first I didn’t have a good answer for her other than “If I were looking for a new job it would be too late for blogging”.  After all, nobody blogs their way into a job overnight.  If […]


My Contribution to the TSQL Challenge #14

What does one do on a Friday night after going out with some friends and having a couple of mugs of suds?  How about doing a T-SQL puzzle? Jacob Sebastian and a team of MVPs and high-powered database gurus are running a series of challenges.  It’s the closest thing to getting an assignment in college.  […]


How Long Are Your Jobs Running?

Today’s post is going to be short and sweet.  About a year ago I put together a procedure that allows me to see the run times of all of the SQL Agent jobs on a database server.  Some might argue that I got a little carried away when I added the standard deviation and variance […]

help with anthropology critical thinking esl scholarship essay editor sites gb how music affects your life best blog post editor site for phd poetry essay editing for hire how society views women popular blog post ghostwriting sites gb esl critical analysis essay writers service for college phd essay writing for hire us grapes of wrath family themes for the necklace best school essay writing websites for school the major theme of "life without principle" is professional curriculum vitae ghostwriting sites pay to get sociology presentation top creative writing proofreading for hire online esl essay ghostwriters services for school cheap persuasive essay editing services usa esl university phd essay sample top masters analysis essay example best essay ghostwriting services au popular admission essay writers service ca write me mathematics application letter composition essay writers site cheap cheap essay writers site usa professional article review ghostwriter website for college personal narrative samples help me write custom admission essay on hillary clinton top critical essay writing sites for school boys and girls alice munro custom case study ghostwriters website au help with custom dissertation hypothesis academic editor site ca do my philosophy letter cheap article writer service online esl critical essay writers sites us cheap papers writing website for college help with top rhetorical analysis essay on civil war buy zoology speech esl proofreading site for mba esl book review editor sites usa popular masters essay proofreading sites ca custom blog editing for hire for university best report editing services uk professional thesis proposal writers site for college popular term paper ghostwriting websites us write papers custom term paper writers site for mba cheap school research paper help popular school personal statement advice esl resume ghostwriters websites for phd the glass menagerie analysis best movie review ghostwriters for hire online professional scholarship essay writer site for mba cover letter editing sites online help writing world affairs essay is the american dream still alive essay help with school essay on usa esl critical thinking ghostwriter services for college do my popular academic essay on lincoln top admission essay writer site au professional cover letter proofreading sites au esl dissertation conclusion ghostwriters services for phd type my custom phd essay on civil war pay for my ancient civilizations article review esl article ghostwriters websites us cheap content editor site for mba scholarship proofreading site au popular movie review ghostwriter service for college only yesterday summary write my literature review best dissertation chapter writer website for phd looking back on your life top school dissertation introduction ideas do my custom dissertation introduction online cheap dissertation editing sites for masters cheap dissertation proposal ghostwriter website for university pay for my professional creative essay professional mba essay writers site ca type my anthropology cover letter buy popular expository essay on hillary pay to write university essay on trump best curriculum vitae proofreading websites for university professional mba dissertation proposal samples custom dissertation results writing websites for school domestic violence essays top paper editing websites uk popular cover letter writing sites for mba sanger rainsford character analysis custom analysis essay writing site for school esl article writer site for mba best college thesis statement ideas help with my sociology case study esl blog ghostwriter for hire for university professional dissertation conclusion writers services for mba personal statement writing service pay for top custom essay on civil war cheap expository essay ghostwriter website for school best persuasive essay ghostwriter service online article review ghostwriters custom admission essay writers for hire top application letter writers sites gb do my biology research proposal best dissertation methodology ghostwriting website online custom dissertation writing for hire for phd buy top blog post type my communication critical thinking popular university essay writers websites online speech ghostwriters service us top home work proofreading websites usa world affairs writer websites cheap university curriculum vitae the natural roy type my popular annotated bibliography top masters dissertation chapter help william zinsser college pressures popular personal statement ghostwriter for hire uk buy cheap scholarship essay on donald trump cheap school essay writer website for college best letter proofreading websites gb order world literature paper rhetorical analysis ghostwriters services uk buy geometry presentation pay to do government papers professional personal essay proofreading services us popular critical analysis essay editing service ca best movie review writers website uk professional college curriculum vitae advice expository writer site au top literature review editor website usa cheap admission paper writers service for mba cheap creative essay ghostwriting site for college esl essays writing websites usa top curriculum vitae ghostwriters sites us pay to write economics term paper cheap masters course work assistance best best essay ghostwriters for hire usa custom curriculum vitae writer service uk best paper writing site usa best blog ghostwriter for hire usa top home work editor for hire gb is euthanasia murder order best college essay on hillary custom personal essay writer site for school split at the root professional report ghostwriter sites for mba esl speech writer website for university best school reflective essay assistance esl dissertation writer services online popular biography writers websites au esl bibliography writer site uk literary analysis of the raven best literature review editor websites au professional descriptive essay writing sites online professional definition essay editing for hire for school top custom essay writers websites usa popular personal essay proofreading service for phd professional dissertation methodology writing services for university type my custom admission essay on brexit professional essay writers service for school thesis statement writer site au top home work ghostwriter site usa best home work ghostwriters site usa essay editing for hire online top business plan writers site usa best critical essay writers sites us pay to get math dissertation proposal esl cover letter writer service for mba best curriculum vitae proofreading service order top analysis essay on hillary custom research proposal writer site for university custom course work writer sites for college top content ghostwriting service for school course work ghostwriter site us pay to write popular problem solving online top critical thinking ghostwriting sites gb the hope hygieia business plan writers for hire uk best movie review ghostwriters site for masters custom dissertation editing for hire gb top dissertation writing site ca top cv ghostwriters services for masters esl cheap essay ghostwriter website for college help me write cheap research proposal popular cheap essay writer site online best phd essay editor sites for phd popular writing site for mba best thesis statement proofreading service for college democratic republicans apush why you should not smoke dissertation results writing pay to get speech thesis help me write personal essay on shakespeare top book review writer websites for mba critical analysis ghostwriters services ca cheap thesis ghostwriter services for mba cheap problem solving editing services usa essays editor services online best custom essay on hillary personal statement ghostwriter services usa esl resume proofreading site ca help with esl academic essay best research paper ghostwriting site online cheap school essay editor service for mba top movie review ghostwriting site uk top presentation editor sites us help with remedial math blog post help me write best college essay on civil war order best school essay cheap term paper ghostwriters for hire for school top literature review writer websites for masters popular dissertation ghostwriter website for masters professional rhetorical analysis essay writing site esl dissertation proposal writers websites custom movie review writers for hire for mba custom phd argumentative essay samples best book review proofreading sites for school essay on summer vacation professional problem solving writer websites for phd custom home work editing websites for phd cheap masters college essay topic definition essay writer site gb cheap cheap essay writing website for school should columbus day be celebrated cheap homework ghostwriter service usa top blog writer sites for masters cheap cover letter ghostwriters for hire us top definition essay editing for hire us popular resume editing website for university popular phd essay ghostwriters website for school popular critical thinking editing website for mba popular annotated bibliography editing for hire for phd cheap movie review editor services help writing earth science homework write economics thesis best school essay proofreading website au write my creative essay on pokemon go professional biography ghostwriting for hire for phd custom university essay ghostwriting services au cheap content editor services for university popular phd essay writing site ca top cheap essay writer sites for university cheap critical thinking ghostwriters site usa vietnam war essay topics professional papers proofreading services ca top paper writers service esl critical essay editing websites online buy top definition essay esl critical essay editing service ca esl reflective essay ghostwriter website antigone creon tragic hero custom masters article topics best creative writing ghostwriting site for masters help with government thesis statement best scholarship essay ghostwriting service uk popular creative writing writers website uk cheap proofreading for hire for mba professional mba report assistance pay to write professional dissertation methodology online popular problem solving proofreading service uk best essays ghostwriters website for mba esl school essay editing service for college pay to get economics cv custom masters dissertation introduction topic article review ghostwriter services us custom dissertation hypothesis writer site ca top essays proofreading for hire for university popular course work writers site online custom college essay proofreading site usa coming of age mississippi popular resume writer sites ca pay for my music biography professional school annotated bibliography sample best personal statement writer for hire esl creative writing editing site online esl descriptive essay proofreading websites for masters esl mba homework advice the seafarer poem analysis popular personal essay editing for hire for school popular thesis statement ghostwriter websites au cheap thesis writers services au custom dissertation proposal writer websites for mba popular research proposal writer site uk pay to write esl best essay on civil war professional thesis ghostwriter site for university popular case study writer sites for university professional college college essay topics summary of anthem esl rhetorical analysis essay proofreading service usa popular cheap essay writing websites for masters esl annotated bibliography writer services professional phd essay editing for hire us esl rhetorical analysis essay ghostwriting for hire uk pay for botany dissertation introduction pay to do health application letter professional cheap essay ghostwriters website for school professional critical analysis essay ghostwriting sites for mba cheap phd essay editor website au professional report proofreading sites for college top critical thinking ghostwriting sites ca cheap term paper writing service for masters esl report editing service for school pay for my top expository essay on usa popular critical essay editor services uk gd folk nation help with engineering essay write my best masters essay on presidential elections esl bibliography ghostwriting site uk pay to get composition creative writing do my custom custom essay on civil war custom problem solving proofreading website do my popular descriptive essay on brexit top cheap essay editing for hire esl biography ghostwriter websites for mba custom best essay ghostwriting services online custom business plan editor site for college custom phd essay ghostwriter sites au buy social studies course work best cheap essay ghostwriting site us do my health personal statement esl dissertation conclusion ghostwriter services for masters professional paper writers service gb help me write cheap persuasive essay on donald trump professional content proofreading sites for college esl argumentative essay editing for hire uk custom personal statement ghostwriters service for university walter lee younger professional mba bibliography sample custom dissertation hypothesis writer sites online cheap dissertation hypothesis ghostwriting site ca esl definition essay writer sites for masters top course work proofreading websites online professional dissertation abstract writing sites us best university essay editor website au top phd dissertation methodology example professional paper writer service for phd cheap mba essay ghostwriting service usa popular literature review proofreading website usa pay to do best personal essay on donald trump top dissertation abstract editing site for mba esl dissertation results ghostwriting services for university pay to get economics thesis proposal top speech ghostwriting sites for university top biography writing service top dissertation hypothesis writing websites for phd popular biography ghostwriter websites for university custom speech editing websites for phd esl presentation writer service ca custom dissertation results writing site usa the role of women in the french revolution popular dissertation abstract ghostwriting sites usa top assignment ghostwriters websites for college popular rhetorical analysis essay proofreading sites gb cheap blog editor site uk research proposal editing for hire ca term paper ghostwriter popular dissertation abstract writer websites for masters bibliography writer for hire ca professional college thesis help custom paper ghostwriters website for university best best essay writer services au professional custom essay ghostwriters website usa cheap paper proofreading service ca popular phd essay writing for hire gb professional critical essay writers for hire us popular blog post ghostwriters site online group minds doris lessing custom article ghostwriting services for university admission paper writing service gb professional research proposal editing for hire us custom homework editing services for university popular thesis proposal ghostwriters website for masters top case study ghostwriter websites usa esl blog writing websites for masters pay for my best reflective essay on brexit popular article review writer website uk esl thesis statement writer websites professional thesis proposal ghostwriter website online the shining bat scene cheap phd academic essay sample masters editor websites pay for astronomy dissertation results help me write leadership research proposal pay to get ecology bibliography custom literature review writers website us best research proposal editor site for mba order astronomy dissertation results esl rhetorical analysis essay writer for hire usa best presentation ghostwriter services for college top letter writer site ca popular case study ghostwriters website for college cheap annotated bibliography proofreading services us professional admission paper editor for hire for university best college essay proofreading services for school esl analysis essay editing sites us best term paper writing site ca order professional descriptive essay on founding fathers popular cheap essay writing websites for phd cheap dissertation results ghostwriter sites gb pay for popular critical thinking online esl expository essay editor website ca top college dissertation proposal help custom creative essay writer services gb help with my thesis statement online similarities between mesopotamia and egypt custom curriculum vitae editing websites usa top mba case study advice geography proofreading for hire top school essay ghostwriters sites usa custom rhetorical analysis essay editor for hire usa help me write best critical thinking custom annotated bibliography editor for hire au best personal statement writing service us scholarship essay ghostwriter website usa help with business case study custom dissertation conclusion writer websites for school help writing persuasive essay on hacking war essays buy top college essay on presidential elections eyes of tj eckleburg popular annotated bibliography writing for hire ca popular thesis statement ghostwriters services ca professional dissertation hypothesis writing sites for university critical analysis ghostwriters website au top dissertation results editor website uk jeb v alabama help writing chemistry homework cheap argumentative essay ghostwriter services us top analysis essay writer websites gb custom analysis essay writers websites uk persuasive writers site au pay to get top scholarship essay on hillary clinton professional definition essay proofreading websites uk top college essay editor site ca critical ghostwriting websites usa roderigo in othello esl dissertation proposal editor websites online masters proofreading site esl creative essay editing site for mba custom case study writing site for college popular article editor site for college buy psychology article custom paper ghostwriting for hire online help writing women and gender studies dissertation overcoming an obstacle essay best annotated bibliography ghostwriter services us top school essay editing for hire usa esl analysis essay ghostwriters for hire esl analysis essay proofreading site ca bourgeois vs proletariat custom masters essay editor service usa popular case study proofreading websites ca write geology article review buy best critical analysis essay on pokemon go do my math speech popular curriculum vitae ghostwriting service gb cheap dissertation proposal ghostwriters website for phd popular dissertation abstract proofreading sites uk custom report writer service gb help writing drama curriculum vitae write me biology critical thinking custom content writer website uk top cover letter writing sites for school pay for my trigonometry assignment cheap resume proofreading service us best critical analysis essay editing services for university geology essay writers website help with my management critical thinking popular assignment writers for hire au esl thesis proofreading site gb professional descriptive essay writer websites uk cheap annotated bibliography editing websites usa professional essays editing site for school esl phd persuasive essay ideas professional scholarship essay ghostwriters site uk top thesis ghostwriting services usa report ghostwriters for hire gb drama ghostwriter service cheap best essay proofreading site for phd custom article editor services best letter writing sites uk write my health dissertation results top thesis writers website custom letter writers website uk best critical thinking ghostwriters sites usa popular dissertation introduction ghostwriters services ca best dissertation conclusion writer for hire for phd professional dissertation abstract editor site for school popular essays editor for hire ca custom critical essay editing service for college professional research proposal proofreading services for mba pay to write cheap creative essay best home work writers site for mba custom best essay editor services for college esl course work ghostwriters for hire ca top descriptive essay writer websites uk custom paper ghostwriting sites for school content editing service au help writing top critical thinking popular persuasive essay writers for hire online