I agree with Andras that it looks ok from a code perspective, but I'd format it to make it read a little better.

I'd do it like this:

CREATE TRIGGER [Prorogation] ON...

I think my generalist mistake in sticking this in the author discussion and not the editorials messed up some of the discussion 😛

How many people know how to redirect output...

Actually, CHECKDB should include CHECKCATALOG and CHECKALLOC.

NEWALLOC is included for backwards compatability and is the same as CHECKALLOC.

http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa258809(SQL.80).aspx

You can open the Structured Storage file in Notepad Or Visual Studio. It's just text, VB code. Look through it and you should figure it out.

However, if it only fails...

Don't forget to send a video in 🙂

We'll use Popcorn in the editorial one morning! Don't worry Popcorn, it's painless!

Building in formatting, like carriage returns, is a horrible use of SQL Server resources. You're asking for a lot of work from a limited, shared resource. As mentioned above, whatever...

I'd really check the values in the Structured Storage file. There were issues in the past where something wouldn't show up in the designer, but still existed in the VB...

I assume you're reading from Performance Monitor. If not let us know.

I don't think I've ever seen this counter die, but as Colin mentioned, usually all the SQL counters will...

BTW, both of these create recovery issues since you have to install something on a new server in a DR situation. Make sure you update documentation and keep copies of...

I know I've seen the green arrow, but can't remember what trick to use.

There are issues with sending mail SMTP via Outlook. For some reason they "stick" in the outbox...

Be careful backing up to drives not local to the machine. Network backups sometimes cause issues.

Depends 😉

If you have heavy tempdb or log usage (based on transactions), then you might get a performance improvement. Keep in mind that data files usually have lots of random...

(possibly) stupid question. Users have run queries on this, right?

As soon as something is read into the buffer, I'd assume the next query should get some type of hit.

The...

The only difference I'm aware of is when the connection is made. After that, things should run the same.

Can you provide more details on what seems slow? I wouldn't think...

From what I've heard from the PSS guys at Microsoft, don't change the worker threads unless they help you determine this. You can get unexpected results.

That's not really a place...