I just had a similar query where I couldn't figure out why these were appearing in the event log. It turned out for us that it was because we use...
Assuming that your site is ASP 3.0 VBScript and that you need to get it back up and running ASAP whilst making some short term fixes I would suggest...
Do you have a clean backup you can restore from and then use something like Redgate compare to examine the differences? If not you will need to make...
This ebook may help http://www.red-gate.com/specials/grant.htm?utm_source=sswug&utm_medium=button&utm_campaign=sqltoolbelt
When the 292 is changed to the problem value how many rows are retuned from this part of the query. How does this compare with when 292 is used?...
Some approaches for storing hierarchical data http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm
Have you looked into using recursive CTEs for this - or alternatively reading Celko's approach for trees and hierarchies?
There is such a huge order of magnitude difference between the 2 results that it seems unlikely to me that you would achieve this simply by moving to...
Is ENCOUNTER part of the clustered index on the table? If so are there any maintenance plans on the live server that shrink the database?
It might not be the SET options themselves. It may be that ensuring that you are using the same SET options as the query running from .NET means that...
Also check the connection SET options as here http://www.mssqltips.com/tip.asp?tip=1304
Hi Satya, I just had a look at your blog post linked to above. In both IE and Firefox I find the text truncated so much that I need to view source...
Hi, We're using 32 bit SQL server. It is a single processor but I think SQL sees 4 as it is a Quad Core (Xeon). All queries are affected...
In the mean time I've found a good tip for the reverse problem (case sensitive comparisons on a case insensitive column) that ensure an index seek...
Yes from this article though it doesn't explicitly say it applies to SQL2005 http://support.microsoft.com/kb/273586 I guess if you want to be really...
I don't see it either. Maybe this was something changed in SP2? Do you get a Reports option when right clicking the DB? If so are any of those the...
Something like this may work to generate a script you can copy, paste, review, and run? SELECT 'DROP USER [' + name + ']' FROM sysusers WHERE...
We are running SQL2005 SP2 and erratically (sometimes less than once a week other times once or twice a day) we get a flurry of timeout errors for no...
Thanks very much for the info above Frank. Adding them to my bookmarks now!
@Satya - Have you read the tip I'm referring to? @Frank - Point taken. I suspect that both UPPER and COLLATE will prevent the index being used but...
Separate names with a comma.
