I think you'd be better off with a template for new tables that also includes a stored proc template to delete older data (#days as a parameter) and includes a...

Some interesting "get there from here" possibilities are coming to mind. Imagine that we allow self-driving cars, but only for < 15mph. Perhaps you could have cars that dropped you...

That's interesting, Wayne. I don't think that's documented anywhere.

Also, I have corrected the typos in the article, which Wayne sent me.

I can't speak for the open source dbs, but for open source Linux we used to have a support contract that was similar in cost to that of Windows.

The other...

Note that you're inserting in a batch here, so MAX(PK) will be the same for all rows you are inserting.

Do you want duplicate identities? Why not just let the identity...

Hopefully the author will update this list and resubmit it. If I have time, I'll try to add these as well.

When you say the job is there, what do you mean? Is this a package execution or stored procedure? Have you looked at the code to see if there could...

I think we have a bit of a language barrier here, but we don't understand what you mean. "Running packages across a server" doesn't mean anything to us. You need...

If you have a question about something not in the article, please start your own thread in the SSIS forum.

SAN. He tells this as an anecdote that a well tuned SAN can really fly.

You really need to learn some terminology as you'll get confused, confuse us, and possibly make a big mistake.

A cluster is 2 or more servers combined with shared storage that...

My advice is to set the space you need for the next 3 months. You don't want to manage space too frequently, and you don't want too much OS level...

It is, that's my neighbor's house.

Can you check what commands it was last running? DBCC INPUTBUFFER? It's possible that it's stuck and needs to be killed.

As John mentioned, more information and preferably code, would help.

I would learn towards a CTE if you have temp tables you are trying to use.