I'm not sure The Thread counts for MVP status, but you never know. Some people certainly have made quite a contribution here 🙂

George, George, George, George

(just in case once wasn't enough)

If it's the same connection, why do you have to do the update first?

If it's last workday and holidays come into play, then you need scripting. There are a few good calendar table articles here. I'd build one and then use a short...

Craig has some good questions. Performance monitor has some counters, but depending on how you answer Craig's questions, they may or may not work

L2 cache is built into the chip. You cannot set it. When you buy hardware, you pick a CPU with at least 2MB of L2 cache.

You definitely need logins and users early, perhaps roles as well. I think you have a good list there.

Here are some things I learned awhile back. I didn't have users...

Whatever code page you used for posting has mangled this so that it's a little hard to read.

Also, no error message is shown

A couple hints.

First, an admin can make a connection to any machine with the C$ share. So if you had a server called "SQL01", you could easily do this:

type \\SQL01\c$\MyTextFile.txt

which...

Note that sp_update_job might be your best bet, script a loop through all jobs

http://msdn.microsoft.com/en-us/library/ms188745.aspx

Again, change this to a distribution list, not a list of individual emails

Potentially you can do an update to msdb, but I would be very careful here.

You should not be sending to users, but to a distribution list of some sort. This...

You can only have one partition function. How do you plan to relate 20110101 with AVMselect? There's no logical way to put these together and determine which values go in...

The only incremental backups are log backups, but they aren't since the full backup. They are incremental from the last log backup.

Full backups have all data, and log records from...

Broken clocks are right twice a day. Let's see the Rocks get through a couple series and win them

Using an identity doesn't mean that you have a large number. You could calculate a column of the date + identity if needed.

Alternatively, why not just calculate the "next" number...