OK, I noticed that an index was missing on the GL10001 table so I added that and it seemed to speed up the query in my tests. I am waiting to hear...
I got an app running on my SQL Server that is starting to slow down on a specific task. I ran SQL Profiler and noticed that the following query is...
Separate names with a comma.