Viewing 3 posts - 16 through 18 (of 18 total)
I agree that it makes sense to not send an email from the trigger. We needed to be notified with fewest lag possible and there were also multiple sql server...
February 22, 2011 at 2:09 pm
#1290114
It will be a lot easier if you were to tell me what do you want to script or create so that I can give you a sample procedure call....
February 1, 2011 at 7:35 am
#1280925
You can put the actual values with an IN statement, this will cause partition elimination.
SELECT * FROM MORTGAGE AS m
WHERE PartitionedCol IN(1, 7, 10, ...)
January 19, 2011 at 2:09 pm
#1275568