• Yes, they do take additional resources. On the other hand, making round trips to retrieve the value takes resources too. Curious as to why you picked the 50k limit?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/