Hopefully Peter will respond soon to this and thanks for a nice post on what you see, Hugo.

We don't necessarily check every article for accuracy. It's a time constraint as...

Where is a moved topic forum?

We do move threads that are mis-posted by people in the wrong forums. It might note that.

Working for promotions has been in a couple ways. This is probably another whole editorial ;), but I'll give a few examples.

If I wanted a manager's job, I'd look for...

There is no way to do this directly. It doesn't return anything.

Run a query to look for the user after it's created. If it's there, then it worked.

Stop and restart SQL Agent. Doesn't affect the database server and is very quick.

Check the service (control panel) to see if there is a parameter.

Otherwise, check and see if there is a command window open. close that.

SQL Server doesn't do table backups. It does database backups and you can search for scripts to handle that. The Maintenance plan can also do this.

The issue is that SQL backups are extremely intolerant of network delays. A file copy will retry itself, but because of the nature of getting the backups done quickly, it...

I've read the Ender series, which is good, as well as the Foundation and Dune series a long time ago. Never any of the add-ons, but I might check them...

What Colin and Jeff are getting at is that the CPU isn't related to the number of users. It's related to the queries and other processes. One user can run...

Colin,

I had heard that the 64-bit OS has less overhead than the 32-bit one because no AWE/PAE paging space needed for paging. Is that true?

Does the 64-bit OS need 4GB...

One more vote for hiring someone. You'll need them even with a tool.

Tools do help, but you should match the tool to the DBA if you can.

Or this: http://www.sqlservercentral.com/articles/Stored+Procedures/2977/

I don't see a good way to do this, even with a cross join. You'll get more cross join stuff out of there.

If this is of any size, you'll run...

Ah, I see.

The problem is that you have matches and you're really looking for some sort of cross join that displays all possibilities. Then you need to somehow join...