Derr, yes, the TempDb mdf file is quickly filling. In my naïve brain, I just think of all related files in TempDB as transaction log files.

In lieu...

You may not get too much more information, but do you have logging turned on for your SSIS package(s)? You can report the On Warning and On Error messages to...

Having come from an Oracle shop, I liken databases in SQL Server, to Schemas in Oracle. Also speaking from a personal perspective, I've yet to find a compelling reason to...

Phil,
  If you don't mind, what is the TFS-way?
--=Chuck

I like the idea of the intervening integration branch. In all honesty, I didn't know until now that a branch could be more than 1 node deep (main->integration->bug ticket). 

This may be the wrong use of terminology, since I'm new to this, but using your approach it's like you're treating everything like a hotfix, correct? Only using that term,...

Just curious, why would this method be preferable over just creating a SQL Agent job and directly executing the dtsx? I've seen references to uploading SSIS jobs into the database...

Thanks for that. In my searches on index rebuilding, they've been in either of three categories:

1) Don't rebuild them.

2) Rebuild them when fragmentation exceeds 30%,

3) Moving to a newer...

First off, I appreciate all of the education everyone's been providing to me over the last year and a half.

After reading over everyone's suggestions, I think there's a couple of...

I came across some other suggestions about rebuilding the stats if you are moving to a new version of SQL Server. In this case, we are, from 2008 to 2012....

No shortcuts then 🙂

So, in the process of applying MSSQL 2012 SP3 CU6 to a new installation (it's probably obvious that I am new to this), I noticed in the...

Confirmed ... the visible instances are running the SQL Server Browsing Service. Thanks Lowell, I can sleep tonight now 😉 Curiosity quelled.

--=Chuck