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.

The log file only has changes to the data in there. If you don't have a backup or a data file (MDF), you cannot recover the data.