Mark Brummel

Browse by Tags

All Tags » index (RSS)
Is Navision to stupid or is SQL to smart
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...