It would depend on your hardware, instance etc, but from memory it takes at least 15 minutes (with antivirus disabled), up to 30 minutes depending on the machine. You...

It will copy the NTFS permissions (known as an Access Control List or ACL) from a working MDF file (where the permissions are correct and work with SQL) to the...

Ferraris in March, quite the bother.

But on an unrelated note, you will need SQL 2000 compatability mode for anything as old as Dynamics 6.5. According to this,...

Try this, open powershell,

cd databasefilelocation

$Acl = Get-Acl "workingdatafile.mdf"

Set-Acl "nonworkingdatafile.mdf" $Acl

Monitoring job history with SSRS http://www.sqlservercentral.com/articles/Job/101563/

or similar Excel with data bars http://www.brighthubpm.com/templates-forms/3418-using-excel-to-create-a-gantt-chart/

Another option is SQLjobvis, http://sqlsoft.co.uk/sqljobvis.php

Remove the Read-Only flag on the NTFS permissions for the MDF file (& LDF).

What sort of alias? DNS or SQL?

The cluster will have a clustered instance name, eg. server\instance. whereas the VM is probably a default instance. A...

tempdev is the data file for tempdb. It's timing out after a very short time, 1.5seconds for 10% growth, around 44MB.

You should really set the growth increments to...

Can you ping the server IP from the client? Ping the server name?

If you can, then add Telnet (from Windows Features) then telnet ip sqlport, eg. telnet 111.111.111.111 1544....

Are you updating a view?

There is a stream aggregate which suggests some grouping going on somewhere. You'll need to attach the actual plan as a *.sqlplan to...

Microsoft recommends it: http://technet.microsoft.com/en-au/library/dd309734.aspx

But also recommends that you change it to 8 during batch jobs or maintenance & upgrades.

To me, that sounds like MAXDOP 0 could be used...

SP2 has been out since July 2012, why are you installing SP1?

The OLEDB wait type is just saying that SQL is waiting on activity occuring outside SQL server which is connected via OLEDB.

The activity is likely caused by some...

Steve, the Edit button is on everyone's posts.. I'm not trying to edit them on purpose, just wondering why the button was there. I thought that I might...

Apparantely to do with a connection timeout, adjust to a higher value:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/94c5f8a5-62ae-42a2-b8ef-c371238d7619/cannot-connect-to-analysis-services-from-ssms?forum=sqltools