Here's the T-SQL statement that has the big delta in execution time depending on the user.

The connection type for all users on our CRM is Windows integrated auth (SPPI).

Any feedback would be very much appreciated!

Andre

exec sp_executesql N'SET LOCK_TIMEOUT 15000;

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT MS.ServiceID, MS.SaleAmount, MS.Service, MS.Status, MS.StatusDate, ''False'' AS Checked

FROM tblMainServices MS

INNER JOIN tblMainServices_B SB ON (MS.ServiceID = SB.ServiceID AND (SB.OriginalDate BETWEEN @BeginDate AND @EndDate) )

WHERE AccountKey = @AccountKey AND (SB.OriginalDate BETWEEN @BeginDate AND @EndDate) AND TimesRenewed = 0 AND (Salesperson = @EmployeeID OR SecondarySalesperson = @EmployeeID ) ',N'@AccountKey int,@EmployeeID varchar(8),@BeginDate datetime,@EndDate datetime',@AccountKey=324071,@EmployeeID='SPO3698',@BeginDate='2012-02-24 00:00:00',@EndDate='2012-08-25 23:59:59'