Archive for November 4, 2004

It was a bug in SQL Server’s query optimizer. I brought a second co-worker to look over the queries and he was able to find a workaround. (a complex one that slows the query down, but IT WORKS) EDIT: When I say slow, I mean slow. The query ran in about 5 seconds before, and now it is up to over 20 minutes. THIS IS NOT MAKING ME A HAPPY PROGRAMMER!

Error converting data type varchar to numeric. YES I’M STILL FIGHTING THIS GODDAMN PROBLEM. I think I’m nearing my breaking point. I can feel the insanity. I’d like to have a chat with the SQL Server developer who wrote the code that produces this error message. Iit would only be a chat. No violence. REALLY.