Yes I have sir, why? Did I...

TheSQLGuru, you are the man, that is the correct answer! tHANK YOU!

Got it, thank you!

I think I found it, it's the Total Sever Memory (KB) under the SQL Server: Memory Manager counter.

That wasn't it, but I'll try that and let you know. Thanks!

I had to fight the storage guys for 2 weeks...

Hi all, thanks for the replies. Yes, I am aware of the issues with shrinking, but this is one of those cases where if I don't shrink the database, 30GB...

Thanks Chris, your solution cut down the execution time by 3/4 and the execution plan cost is down 2/3. That's fantastic!

Yes Sean, you do need more patience, nowhere did I say that I didn't spend any time on this myself. In fact, I have spent 2 days on and...

Thank you!

Hi Keith, which book/site/etc. do you recommend for a DBA to start learning PowerShell? Thank you.

OK, 2 minutes after I posted, I checked BOL for sp_start_job and it said the following:

"By default, members of the sysadmin fixed server role can execute this stored procedure. Other...

Hi everyone, thanks for the responses!

I did set up a linked server, gave the user db_owner in msdb (just for testing purposes) and used a 4 part name...

Thank you Mister!

Yes, I just did and they are enabled. There are other operators that have no mail issues. I don't know why certain operators have issues with mail.