if there's an faster way to convert the xml into a list of 'parameters' and values (which is what the Parameterfilter table is)

Yes there is but you need to be...

If you changed to clustered the Bookmark lookup should be gone!

the fastest operation you can get is a clustered index seek. And you are there! Now you may be running...

That still does not means that you can't change the primary key to non-clustered and this one to clustered

Can you make t_MemberAccount.SSIN CLUSTERED ?

Like explained above "with encryption" is the easiest and more portable but it can be decripted. If you really need protection only extended stored procedures will help you ("a bit")...

Most parsers get rid of the spaces internally and tokens are the ones that define the "limits" on the language. Depending on the way the parsing is done it may...

Believe me it is going to happen!

You can use WITH ENCRIPTION on the procedure declaration, you can create an exteded stored procedure using C++, you can create COM Component and use sp_OA* calls but the real...

Yeah ... Yeah .... Yeah

Excellent definition catch-22

That's exactly what we all said

I am going!  I just thought not, for a moment 

It is getting weaker by the hour

Just wait till you get married. You'll know what I mean

I was afraid of "Rita" but apparently it is turning east and weakening

... did you...

That script uses sysindexes!!

if you are planing to use it just run the following first!

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS   

and you shoud be OK

Cheers,