Run SQLIO to test the writes on the db server. You should be able to guess the bandwidth from there or issues with the other server.

Not sure what you can...

Please don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic488310-149-1.aspx

If you click the authors name, then there is a page listing their articles.

There's one long page, which of course I can't find now (not linked), that has every author...

Upper left of this pane is a link for "Control Panel". Once you pick that, down the left side are various options. Forum and topic subscriptions are at the bottom....

The database backup backs up all pages, then it scans the logs, grabbing pages needed to cover transactions that have taken place since the backup started. In this way it...

Very interesting responses and thanks for the debate.

I'd like to point out a ocuple things. First, there's a huge gap between completely managed PCs and no restrictions whatsoever. Even Google,...

It shouldn't need to be enabled. DMO is the set of DLLs on your client that will connect with standard protocols to SQL Server. The set of functions sent in...

Not sure I've seen a good one. I know lots of Oracle like things are in PostgreSQL, so that may be a good start.

are you looking for things in terms...

Jeff has a great explanation, and to me, the readability and the simplification of code are reason enough to use them.

There is a check box in the wizard to "save the package", which will save the SSIS package that you can rerun.

You'd have to test on your system, as mentioned, and I'd check the execution plans on both, but I'd lean towards #1.

Is this only in Management Studio or in your application? I thought there was a max char returned setting in SSMS.

Brie sure that you consider Mozzarella!! Pizza, baby!

I think points have been made clear and at this point, I'm shutting down this thread. If you disagree, send me a PM, but at this point I think we've...

I'd second Michael's notes. Wait for a quiet time to do this.