And run Profiler to see if things are moving while it's executing.

It's a syntax error, you need to see the query to figure out what's wrong.

It's going to be one or the other all the time.

They're planing SQL 11, or about to, so I'd encourage Jeff to hit the MVP groups and post suggestions for...

Space might be available for new rows, but they aren't necessarily reused. Your clustered index might cause things to be more spread out, and depending on the values, pages might...

Terry has it correct. The backup process is optimized to throw pages out as quickly as possible and it has no tolerance for IO delays. So if the network hiccups...

I think you'd

select @a = myval, @b-2 = myval2, etc.

from myCTE

How current do the reports need to be? Database mirroring and snapshots (if you have enterprise) can help here. Or replication to a second server.

This kind of sounds like a test question, so I'll ask you to show some work.

As a hint, a subquery and a max() aggregate can help.

No idea. the column is undocumented and so I'm not sure anyone has decoded all the values.

That's a little strange. I'd think that a user would have problems with xp_cmdshell before DTSRun.

Does the proxy have access to msdb?

there isn't really a good way to do this. You could move to dynamic SQL, but that's not really recommended. You could cause yourself other issues.

I can understand that you...

The newsletter easily fits on about half my 1152x864 screen (image attached).

I'm guessing that you have pictures blocked. Outlook leaves large placeholders in their place which affects scrolling.

Also, please post...

I think the author is OK, and hope we'll see more.

Again, apologies.

Hey, I resemble that remark!

I didn't see that in today's newsletter. I have Outlook 2007, and my resolution is 1152x864. A message window about 2/3 the screen shows the newsletter formatted fine.

Can you send...