It very much depends upon data volume & cube algorithm. If multidimensional processing is complex, it will certainly take time.

There could be other reasons as well for example server configuration...

Log the alerts in some tables via triggers. Create a job to scan for new records periodically. If you find new records, call the sms application (third party).

No offense but will the users consuming this data would be able to interpret it properly?

declare @str varchar(100) = 'Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.'

SELECT SUBSTRING(@str,1,25) AS...

Per BOL:

CXPACKET

Occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait type becomes a problem.

More: http://msdn.microsoft.com/en-us/library/ms179984.aspx

In this particular case Yes.

But I am giving you once scenario. Please answer to it for my better understanding. The application uses a login XYZ to connect to the...

I am sorry but I am not able to understand your requirements. Why hundreds of users are sitting on the server if you don’t want them to connect?

Per BOL:

TRUNCATE TABLE (Transact-SQL)

Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE...

What about copy database task? 5 GB database on 2 VMs on LAN, it shouldn’t be a problem.

Try it with wizard & save it as SSIS package, schedule & run...

Physical distance plays a vital role in data transfer. Little Birdie might take 5 days to reach a destination 5K miles from the source database server.

It should not be a problem. Create (or retain) few logins which are required for routine operations and disable (or drop) remaining logins.

For the retained logins provide minimal permissions based...

Please don’t complicate the things. For your requirements FULL Backup & Restore is most suited option.

PS how far is Source and Target database Servers? Do you have any bandwidth constraints?

The biggest strength of Agile Development is its biggest weakness as well i.e. ‘narrowed vision’. You don’t see the problem as a whole but as bunch of problems jumbled together,...

Nicely Done!

Discusman (1/30/2012)

Yes, I have already submitted my application for "Healthcare Informatics Certification Program"....

If you have options to choose between Windows XP and Windows Server for SQL Server, I guess the easy answer would be Windows Server.