There's a rollup from last week that's post SP2. Test and apply that.

There are a variety of tools from Idera and Quest, but they usually need some customizing from you.

I've tended to roll my own since many of these tools end up...

If you're paging, then you can do

select top 25 clientname from tbl order by clientname

for the first page. You can add a WHERE clause ot limit things as needed....

The licensing has changed since the OP, and so that's not an problem. Honestly it seems that people have issues they post about managing the multiple instances. You definitely need...

Which login is the user under Databsae->User mapped to? This does not have to match the Security->Login names at all.

Is field1 AND field2 indexed? The ORDER by requires a tempdb operation, as does the TOP 100. If they're indexed, then the optimizer can easily shortcut the first matching 100...

Also, which field is salary? It seems like you want to compare the first number and the second number at different places.

Maybe you can tell us what you are...

Don't forget there is no ordering in the table. Just because you see data returned a certain way doesn't mean it exists that way or will always come back that...

I like either 3 or 4 the best, though I might actually create a view for the purposes of querying that unions the two different tables together.

Let's hope they aren't checking those backups and using MAID. Maybe we'll get a crash!

It does happen (outsourcing DBAs), but I doubt it would be only DBAs. There are a number of remote DBA service firms out there and they seem to be successful.

Office 2007 may be more compatible, but the ribbon crap is annoying. I wouldn't care so much if my ALT+I popped the INSERT menu, but they've gotten rid of the...

My thoughts when writing this were that some companies are promoting blogs. Not all of them, but some are. It's a marketing effort to be sure, but it does allow...

Interesting comments and thanks for the debate. I liked the different perspectives.

For the record, I felt bad after writing this and I've been reading a bit more and watching some...

There are some tools that help. I know that if you were to have a Blogger or one of the popular sites, Word 2007 can actually publish to that site....