norbert.manyi (10/2/2012)
My first idea (given my coding background) was to create functions to be used like
select * from tbl_Users U where fn_IsUserActive(U.UserID) = 0
but I don't know about how much that would degrade performance...
A lot. That query form means that indexes are useless and the only way to process that is with a scan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability