What is interesting is that people seem unable to stop using them once theyy have them. Many meetings are effective shambles as it's apparently OK to be dealing with business/pleasure...

Marvin, from Hitchhikers Guide To The Galaxy

"Simple. I got very bored and depressed, so I went and plugged myself in to its external computer feed. I talked to the computer...

The answer is probably to educate the programmers in the best way to create the queries rather than allowing them to do it inefficiently. Even if you agree that hardware...

Of course being English I get a completely incorrect day and date - but hey, that's what happens when you change the defaults.

I thought the default for the Enterprise server (any edition except desktop) was "Full Recovery", so why would the option become "Simple" after a reboot?

I assume you have "SELECT" in front of the statement, i.e. :

SELECT CAST(SUM(FileSize)AS BIGINT) MB, CAST(SUM(FileSize)/1000 AS BIGINT) GB

from o_file

where volid = 16 and groupid = 221

and not:

CAST(SUM(FileSize)AS...

Doesn't like single quotes around the terminator, use double quotes (").

Chris.

Thanks Dan, I followed Technet suggestions, including DBCC over all the DBs with no joy. My developers can't see a problem, the process ID no longer exists, so I had...