I have attached an execution plan whose components are adding up to 248%
Though I was able to resolve the performance issue I had, I am just curious to know why this happened
Has anybody seen such occurrence before and does any know the reason?
The SQL Server version is 2008 and I get the below result when I select @@VERSION
Microsoft SQL Server 2008 (SP3) - 10.0.5770.0 (X64) Dec 29 2011 17:33:21 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
How to post data/code on a forum to get the best help - Jeff Modenhttp://www.sqlservercentral.com/articles/Best+Practices/61537/