I think this could work as well; it calculates the size of data cache per database.

Execute sp_msforeachdb @command1 = '

Select

''?'' As DatabaseName,

DataCacheSize = (Sum(cached_pages_count) * 8.00)/1024.00

From...

Sounds to me like you may want to use the MERGE statement. You can read this link on books online and see the examples they provided.

Mani,

I am not sure if you have been able to figure it out yet. I believe that you will see the FSAGENT wait type whenever you are using FILESTREAMING/SQL...

Okay. What are the Max Degree of Parallelism and the Cost Threshold values for the server? Is it for OLTP/Datawarehouse/OLAP? I know that service packs shouldn't change...

I have not experienced anything yet. Did you check to see what wait types you are having? CXPacket or SOS_SCHEDULER_YIELD? If so, have you identified those queries. ...

Okay, so I forgot to include the enabled flag for the schedule. Here goes version 2:

Select *

From msdb.dbo.sysjobs j with(nolock)

Inner Join msdb.dbo.sysjobschedules js with(nolock) on js.job_id = j.job_id

Inner Join...

By the way, great post. I took the query provided and furthered refined it for jobs that have no history; you may have created a job yesterday that was...

Gila and Paul, Thanks so much for your input. Apparently this steps can only be performed using SQL Scripts, unless I'm wrong is this possible to do from...