HA! This was like reading the story of my own daily struggle with kids and Minecraft. I could have written the same, word for word.

"Mod" is a...

Additionally you can add this to script ALL logins:

SELECT @List = COALESCE(@List+',' ,'') + loginname from syslogins

set @List = @List + ','

Instead of:

set @List = 'BBLEARN,BBLEARN_report,BBLEARN_admin,BBLEARN_cms,BBLEARN_stats'

set @List = @List...

1) tune queries/indexes/etc. Reducing IO demand can open up all kinds of IO headroom

I can add indexes that that's about it. I can suggest changes to queries, but can't change...

1) tune queries/indexes/etc. Reducing IO demand can open up all kinds of IO headroom

I can add indexes that that's about it. I can suggest changes to queries,...

Thanks. Problem is my admin is still living in 1995 and probably doesn't know what a LUN is. So the weakest link in this chain is the network...

I have a similar question.

I told the OS admin that tempdb needs to be off C: with the bins and put on a separate drive. I also recommended the...

I am having a similar problem. FYI: ItemValue =nvarchar(4000) and the data is either a valid date or NULL

Here is the issue. I get the following error......

Thanks. You have been extremely helpful.

Wow, that was too simple. I've been looking at this package for hours. What is the best method for sending the email from the step? CmdExe, powershell?