A process that's been running hundreds of times a day for almost two years gave this error message last night:
---------------------------
Crystal Reports: Database Error
---------------------------
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Intra-query parallelism caused your server command (process ID #56) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
---------------------------
OK
---------------------------
Nice, eh? I don't even know where to begin. I read what Microsoft has to say about it so I can only conclude that it's a matter of out-of-date statistics or a fragmented index, since nothing has changed on that server as far as I know.
Anyway, a new one for me.
[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.
[sub]The best part about anything that has cheese is the cheese.[/sub][/color]
---------------------------
Crystal Reports: Database Error
---------------------------
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Intra-query parallelism caused your server command (process ID #56) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
---------------------------
OK
---------------------------
Nice, eh? I don't even know where to begin. I read what Microsoft has to say about it so I can only conclude that it's a matter of out-of-date statistics or a fragmented index, since nothing has changed on that server as far as I know.
Anyway, a new one for me.
[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.
[sub]The best part about anything that has cheese is the cheese.[/sub][/color]