No matter how you load it, if you go with one large transaction, then you have log issues (and potential rollback issues). SSIS is essentially a C# application written to...

It will take time and you'll need disk space to house the index. It will require resources, so you might want to pick a low activity period to do it...

sp_help_job is what I'd use as well.

First, lots of companies won't do this because production data should not be disclosed to QA. Financial stuff, identity, etc. You're asking for issues. Lots of companies I know of...

Blandry, I think it depends on what you're trying to achieve. I have development experience, but I'd be a low, intermediate developer at best in terms of coding skill and...

But we can remove the old ones! :w00t:

If you must use one physical server, I'd do one instance. Two instances can be tricky and it sounds like you don't really know how this works. In that case...

With 2005 and 2008, they aren't necessarily required for auditing. Actually you could argue that Profiler/trace means they weren't needed previously either. They do many auditing easier in many cases,...

dbcc shrinkfile.

Only shrink it to the size you need for peak size between log backups. Not what's used now.

As soon as you upgrade to refrigerators to cool the beer, I'll take you up on that.

Actually if you're near Cambridge, let me know. I'm likely to be over there...

You cannot reset your password, but you can change it on expiration.

Not sure I'd hire anyone who chose the last option as anything other than a joke. Not sure I'd...

Roger,

Thanks for the update. Good to see the SQL team is watching and responding to the community.

I'd argue with the Patriot Act, I wouldn't trust the other side any more.

one instance, SQL Server can manage resources within itself.

multiple instances - resource contention, tempdb separation.

I wouldn't necessarily look to put a warehouse on the same instance as other databases. Typically...

Make sure you maintenance plan logs to the file system so you get more details. We can help if you don't understand them.