Please follow the second link in my signature on posting code & data, but we will need DDL, sample data, logic and expected outcome.

With that information we will be able...

% outside of a like clause is the MODULO operator and returns the remainder of the division of the calculation

Modulo - TSQL

I would only do a backup of the OS using something like Acronis or doing a snapshot if its a VM, SQL should be ok as your not doing anything...

Easiest way is

In SSMS, expand database, expand tables, right click table, expand script table as, expand create to, click new query editor window.

Wrapping the output column in an ISNULL should resolve the issue.

SELECT

SUM(SQ1.Total)

FROM

(

SELECT

SUM(ISNULL(Qty,0)) AS Total

FROM

Trans.Sales

UNION ALL

SELECT

SUM(ISNULL(Qty,0))

FROM

Archive.Sales

) AS SQ1;

Edit had ISNULL outside of the SUM instead of inside the SUM.

I take it you haven't capped SQL's maximum memory and left it at the default 2TB.

SQL will manage its own memory and release memory as and when it needs to...

Please follow the second link in my signature on posting code and data and I am sure you will get a more precise answer to your problem.

But I am guessing...

Primarily then it will be looking at the backup routines.

Exchange journalling is basically a log of what happened and when for compliance and regulation, which is pretty much what the...

Have you set a max memory limit on the server or is it left at the default 2TB?

If default change it to around 2GB less than total server RAM.

That would come under recovery and depend on the backup routines of the database in question.

The only times I have heard of journalling is in finance systems.

I would suggest going...

Journalling in what aspect?

Good question, prompted me to do some investigation on that as I have never wrapped DBCC CHECKDB within a TRY CATCH block before.

For configuration, this should help http://msdn.microsoft.com/en-us/library/ms159624.aspx

For report designing and deployment, check out the stairway to SSRS http://www.sqlservercentral.com/stairway/72382/

Yes, just follow the installation media and select the right options for what you want to install.

Maybe this will help http://jahaines.blogspot.co.uk/2010/04/t-sql-tuesday-005-creating-emailing.html