Also not mentionned is to delete the old file once you have restarted SQL.

Well MSDN says:

"Logs a user-defined message in the Microsoft® SQL Server™ log file and in the Microsoft Windows NT® Event Viewer."

I would definetly say that "Windows Application Event Log" is...

Any way to clear this "parameter sniffing"?

Still don't know what the problem actually is, but somehow it is disappearing from selected databases. There is no rhyme or reason for what database gets fixed, some I have...

quote:

---

I would guess you have to update the statistics

---

I've dropped and rebuilt indexes and dropped...