isuckatsql (10/4/2013)
The more i used normalization, the slower the query performed, so it has gradually been denormalized, to improve performance.
Oh dear, that's really not going to help overall performance in the long run....
Denormalisation, hints, catch-all queries, you've got a lot of things that are very likely to cause you a lot of problems there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability