Using Aliases is the where clause should not improve performance. The query plans should be the same.

My major issues are diet (I hate veggies and love chocolate), procrastination, and eating out. I'd go out for every meal if I could afford it.

You can't. You just run a trace a trace using the Standard Template (be sure to include the TextData column for the RPC completed event) and add filters on...

Do you have the database set to AutoClose? That should be turned off if it is on.

Are you tracing the starting and completed events? That would explain seeing...

Have you run Profiler like I suggested to see what is happening behind the scenes? All SSMS is doing is issuing an update statement so there has to be...

Huh?

When you create a login for SQL Server you are only granting access to the server, unless you place them in a fixed server role, not to any databases. ...

What is in the TextData column of the SP:StmtCompleted events and the RPC:Completed events. Are you sure that they are related?

Run a Trace, SQL Profiler, when you attempt to edit the data in SSMS, then my guess is you will see an update statement with your one character followed by...

SP:StmtCompleted shows each step in a stored procedure, like IF @parameter is Null Then, while RPC:Completed and SP:Completed events are fired when an entire RPC call or Stored Procedure is...

This article has some good information and links. And this is the BOL link which I have used to do a command line install in the past.

Let's just say that I would not recommend changing this setting. As the person says in their comment, this is not supported by MS so why make that change....

Really the WITH ENCRYPTION option or a third party tool is the only way to go if you are putting all the business logic in the database. Personally I...

Check out this thread: http://www.sqlservercentral.com/Forums/Topic613439-146-1.aspx. You can also use a DDL trigger, see BOL for how.

Seconded.

Please post your .NET code. Then we may be able to help. It seems like you are not correctly initializing the parameters in .NET.