My ideal situation is to have a separate server for running Integration Services and other non-database-engine apps, e.g. PowerShell scripts and .NET console apps. The config lets me know the...

I thought that deletes were a major cause of internal fragmentation, though not necessarily external fragmentation.

I'll second that comment. If you have to use SQL 2008R2 as a crutch, so be it, but it is clear the way Microsoft has shifted in terms of the...

DBA_SQL (6/11/2012)

---

I have a question with Identity property

Is there anyway where we can insert the data directly onto second column by ignoring first column.

I have a csv file, which had...

It can be done on 2005 but I have no idea if it is a good idea since I have never tried it.

Description of support for network database files in...

Kindly post findings or resolutions here so the community can benefit.

When you did your teat where only "rpc out" was enabled were you using SQL authentication or Windows to auth to the remote server?

Yes.

Peer to Peer replication should handle your replication needs....

ANSI-89 style joins are supported in 80 compat mode, which is not an option in SQL 2012.

If you want to play, and will not need to have databases larger than 10GB, then SQL Express may serve you well. It's free and includes Management Studio:

Microsoft SQL Server...

Here is another article for your reference that helps explains why bulk logged is not reducing the size of your tlog backups:

Using Bulk Logged recovery model for Bulk Operations will...

You're welcome.

From your later posts it sounds like you're supporting another group remotely. If that is the case, or code changes are not an option to add logging, then might I...

If a deadlock were occurring I would expect the SSIS package to fail if it were chosen as the victim, or proceed if it survives the choice. How long does...