I could add the no lock, I have been trying to avoid any changes to the base code so the developers wouldn't need to be involved. Making the leap to...
The collation is the server default. I totally agree wit the three points you have made and have quoted them to managers...unfortunetly this is a...
The optimzer is choosing a Clustered Index Seek this morning..only one index. Heres the table and index build statments. Thanks for your help....
We are currently experiencing a problem where CPU is up and down but running a steady 80%. One application running WebSphere, so the jdbc...
Separate names with a comma.