Then the only way would be to restore the database from backup.

Restart the SQL service.

Default is READ COMMITTED, typically only change it if you are having problems, and I always stay away from READ UNCOMMITTED

Probably down to the errors in that assembly, I would sort that out first then try it again.

Also if possible re-write the view and do the normal troubleshooting steps, index maintenance etc etc.

Certainly looks like it, and especially so with the parameter names @p__linq__0.

95% of our website is in EF and LINQ and the queries look like that.

Welcome to troubleshooting entity framework and LINQ.

You probably have a bad case of parameter sniffing and a cached plan which doesnt meet the needs of the query.

If possible write it...

Yes as it has to replay the rebuild on the mirrored node.

http://www.sqlmag.com/blog/sql-server-questions-answered-28/database-administration/efficient-index-maintenance-database-mirroring-140758

We are looking at replacing our current Telligent installation with either a custom built, or another 3rd party forum group community system. So thanks for this, will be one...

leaf level is all the data in all the columns the index covers

look at the diagrams in the articles Gail has linked to, they are self explanitory

Also post the definition of prc_invoice_rmdetails

Depends, if you have enterprise edition you can do you rebuilds online, providing that the index columns are of a compatable type, but usually do it out of hours.

Your sample data doesnt match the output, we need the output to be based on your sample data, so either change the data or change the output to match.

Depends on the table definition and the columns

Index Key is the column

Index Key value, is the data in the column

It communicates directly with your AD server as an automatic request if it has the right permissions to do so, it doesnt need the SetSPN tool to be installed.

SetSPN tool...