Just a terminology thing...

Hashbytes doesn't encrypt a password, it creates a cryptographic hash. Point of a hash is it's one way and deterministic, which is why it's good for passwords....

Install SQL then patch it to the latest service pack before you try using it.

What are you installing, what OS are you running?

No, Char and varchar are fine together...

See the lock compatibility matrix - http://technet.microsoft.com/en-us/library/ms186396%28v=sql.105%29.aspx

Write a typical select from the view, run it with Include Actual Execution Plan enabled.

There's nothing special about a CTE with it comes to exec plan. It's just a named...

Yeah, an Oracle forum. We're a MS SQL Server site, so solutions posted here are generally for SQL Server, especially since you never gave any hint you were working with...

You have security vulnerabilities in that. Specifically SQL Injection. DO NOT concatenate user input into a string which will be executed. It is perfectly possible to...

Yes and there's a code link on the left-hand side which does work. (though I haven't checked what it includes)

Forums are going to be quiet today. How am I supposed to keep myself entertained on a Friday afternoon at work now? 🙁

I think you have a key lookup deadlock here (ref https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/)

Can you make that existing index clustered?

You can still use either Jack's or my solutions with a value passed from a user. You'd just need a...

Tell then they don't have a clue what they're talking about.

Unless this is a SQL Azure database, a single user absolutely can access multiple databases.

Please post the table definition and all indexes on it.

Could be there's something in the code you left out which is doing something odd. But we can't tell.