You could build a maintenance plan with SSIS that just does maintenance cleanup. Probably be easiest.

No problem keeping connections open. If they don't use resources (queries), there's very little overhead. Might be sure you have error code in case the connection gets dropped.

I'd actually consider...

I was going to suggest what Michael posted.

Since I often find myself going back a few events, I'd actually keep a query around to pull everything from today.

select

...

...

Great explanation and I'd add that they did a great job with the DMVs exposing almost everything you need, so you don't really need to hit the base table.

Plus the...

It's actually easy. Inside a company, you buy CALs. If the people are authenticated users, Windows Auth, or just AD accounts, they should use CALs. Per processor is for unauthenticated...

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...