What are you using to get the dropdown?  How long will you keep that database?  Depending on what you are trying to accomplish T-SQL may not be where you want...

Someone didn't really do that

I liked the calls... I just ran an update on production, but forgot, or had the where clause commented...

As for dynamic where (if you must).  I personally would suggest doing this with dynamic sql and sp_executeSQL with parameters for those fields that you end up supplying.

At the...

First of all, I don't believe you have posted any of the details about how many rows are in any of you table, or about the users.  Just that you...

where did you read this? 

This sounds like SSH documentation.  Or some sort of security documentation.  This is talking about a "public key" something that you can give to anyone...

Would I be wrong in assuming that you put the model database on a network drive?  And more than that the tempdb too?  I think that is your issue. 

Haven't heard the issue, but did you also apply the patch to the Management Studio system?  (I am assuming they are not one in the same)

Personally I am not a fan of putting anything other than the OS on the C: Drive of a server.

Can you submit the DDL for the table, and the DML for the insert?  Might give a clue where the issue lies. 

Can you post the statement?  I have a feeling that there is a cross join.  If you are saying that you should be only updating 28 of the 28M records,...

I think the decision has more to do with your SLA than it does with necessity.  There is always the possibility that one company could impact the whole system.  If...

I tested it (and couldn't find any issues), but still chose not to use the in place upgrade.  I was just not comfortable with not being able to QUICKLY cut...

Have you checked the System Logs?  Perhaps the system is re-starting for some reason.  Also what about the service itself, did someone add some options to start it in single...

Uninstall/re-install will not remove the files, but that doesn't prevent someone from just deleting the directory.  Even with a small shop, you should setup some sort of backup process.  What...

I didn't test it, but I believe it will work.  This should prevent those operations from the view, but will still allow them if they access the...