Currenly I am again fighting with SQL2005 at a customer. Many, many reads on tables whilst there are perfect and selective indexes. Now I've never experienced this problem on SQL2000. SQL always uses the right index for the query. I also know Navision has not changed the communication with SQL. What...
Posted to
Mark Brummel
by
Marq
on 08-21-2007
Filed under: SQL, Performance, index, recompile, Navision, indexhint, bug