Use ISO based date formats or if you must do DMY set your connection to use DMY formatting

http://en.wikipedia.org/wiki/ISO_8601

SET DATEFORMAT DMY

Otherwise the general default is MDY resulting in 28/02/2014 being the...

You will need to modify the attached script and put in the Database names, logical and physical file paths in the ############################ areas and then stick it in the databases...

You would need to speak to your mail admins to ensure that the email server your using accepts connections on the port in question. If it does then your...

Check the agent for any jobs which have been setup to run CheckDB.

Do you ever perform CheckDB's on your databases manually?

Yep those steps will resolve the problem.

You will need to ask a few more questions now to the business to determine how to stop this from happening again, primarily around...

SSMS may have been installed as a 32 bit version, doesn't mean that your server is 32 bit.

To check connect to your server via SSMS and run PRINT @@VERSION

You should...

You would need something to be running outside of the SQL instance, for example a powershell or WMI script which checks the service at regular intervals and emails you if...

This will probably help you out and it details how to get the hierarchy out of the AdventureWorks database for Manger vs Employee

http://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx

What object is object_id 1913773875? If its not the table you have already detailed can you provide the same information for that table.

Can you post the deadlock graph from the system_health extended event?

Have you checked the windows error log?

Can you post the deadlock graph from the system_health extended event or by switching on traceflag 1222

dbcc traceon (1222,-1)

If your filegroup has 18 physical files, then the objects on that filegroup are spread across all 18 physical files. So your table will not just live on 1...

Try this

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1d2cb76b-642f-4067-9667-aacdbc142f74/microsoftsqlserversqlclrproviderdll-ver-10xx?forum=sqlsmoanddmo

Strange that is not referenced in the query plan then as there is no mention of T659.

Can you post the output of the below when running it inside the databases...