Viewing 4 posts - 1 through 4 (of 4 total)
My two cents on compacting the procedure so it does not recompile.
1) Be careful with unknowingly converting a field in the WHERE clause that is a data element in a...
November 28, 2007 at 8:59 pm
MS really helped out with your decision in SQL Server 2005 with the Standard Edition spanning 1,2, and 4 processors. So, with two 4 processor Standard licenses (about $16k...
November 26, 2007 at 8:08 pm
When I posted the results of my own testing several years ago, I assumed that since explicit RI (well defined PK/FK relationships) had such low 'penalty" w/r to using IF...
November 21, 2007 at 7:01 pm
In back-to-back test, I found the following with SS V7 (I know a while back but probably still valid): No RI is the fastest (of course); RI enforced by SQL...
November 19, 2007 at 7:20 pm
Viewing 4 posts - 1 through 4 (of 4 total)