Viewing 4 posts - 1 through 4 (of 4 total)
After reading some informaion on parameter sniffing I've taken the original query that was causing the problem and found that by using OPTION (RECOMPILE) on one of the SELECTs the...
June 9, 2009 at 4:07 am
Yes, the code that was commented out acually runs inside the function. It was commented out so I could test against a database table.
I have taken your advice and collapsed...
June 8, 2009 at 8:49 am
Here is the code, extracted from the function for testing purposes but it displays the same behaviour:
DECLARE@RESULT
TABLE(TMacIDINT, IOID INT, DateAndTime DateTime, Data REAL, TagVARCHAR(20),
IOName VARCHAR(100), TMacName VARCHAR(100),UOMNameVARCHAR(50),
IsDigital INT, ErrorDetected...
June 8, 2009 at 5:21 am
Viewing 4 posts - 1 through 4 (of 4 total)