You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is that, if the SSIS...

Start by modeling the data the business needs. Design a database that supports that model. Then work out how to get any useful information from the old database...

Beyond Matt's general data about heaps, these two particular tables have other differences that are important. One has a GUID as the leading edge of the PK, one has...

Steve Jones - SSC Editor (7/26/2012)

derek.colley (7/26/2012)

Sorry Abel but this is god-awful advice. I recently got...

Yes, as you've written it, it's a pretty standard and usual sort of proc. That's the way it's meant to be used.

I'd have to have some sample data, and table structures to insert it into, to real nail this one down.

My first suspicion would be that the monthly depreciation has a...

Is LPAR unique in the IHS table? If so, select from there, and use Inline Select statements in your Select clause, instead of joins. That usually fixes this...

The proper way to write an Insert Select statement is to list the target and source columns explicitly. Leave out any columns you don't want explicit values for (like...

I'm not sure what you're asking here. Merge, as you've used it, is good for "upsert" operations (update/insert). That's largely what it was created for. As such,...

Have you set the language property of the report to one that works that way?

marcia.j.wilson (7/25/2012)

GSquared (7/25/2012)I used to work at a company where your review had to include scores from 1-10 on various aspects of your job duties. Wasn't ranked against others...

Eric M Russell (7/25/2012)

Style 120 actually doesn't strip out the time portion of the datetime, so what they're doing makes no sense....

Check the job posting. If it's like the usual ones, it asks for a full set of skills that have nothing to do with being a DBA, as well...

The reason they're doing what they're doing is that they don't know how to properly deal with times in DateTime columns. Format 120 strips the time out. They...

Modify your error proc (usp_GetErrorInfo) so that it inserts into a table, then you're good to go.