The account needs the rights to stop the service, so this is usually power users or administrators.

My Google-Fu isn't strong at this time in the morning, so lookup the permissions...

http://www.sqlservercentral.com/Authors/Articles/Gail_Shaw/148127/

Gail has wrote some good articles on indexes, use the above link and read the "Introduction to Indexes" articles.

Typically no as thats the SA login and runs system process, now depending how you have your security setup it might be that everything is logging in as SA, which...

Mini Chopper

Create a report as you want as the template, then deploy it, then ensure the users dont do save as over the top of it and mess up the template.

Please be patient, we are all unpaid volunteers posting in our own time and sometime it takes time to get an answer to a problem.

SSRS cannot natively do tabbed reports...

Yep thanks both, case of the afternoon slump, need more coffee to keep going.

WHERE

ISNULL(SUM(BF.GLOBAL_FEE_TAKEN), 0.00) < ISNULL(SUM(BF.FEE_AMOUNT), 0.00)

Your where clause is not SUMming the data, so while 10200 < 32700 = TRUE, that is not what is actually being checked in the where.

Well there you go then, you where running into the UNKNOWN section of the predicate and in turn it was filtering them out as if a value is NULL SQL...

So 0 for a Ammount paid, so is that 0 due to the ISNULL or is that 0 due to the sum of the values?

What is the value in the two columns in the where clause, I am guessing that one or both are NULL due to you wrapping them in ISNULL in the...

Query the tables individually, then you should notice the common columns between the three tables

Job_ID & Schedule_ID appear in 4 times, in different tables, this is the linking route between...

Restarting SQL is not a good idea as it flushes it's cache and when it restarts has to build the cache again which makes performance worse (usually)

A good place to...

well, if thats the case then query msdb.dbo.sysjobs, link it to sysjobschedules then link that to sysschedules for the job id.