It all depends on the load the application will create. If not very much then even the desktop could technically be overkill. But for the basics of what you say...

Create a composite unique constraint or composite primary key (same basic thing in this case) on both columns. Using EM table design is easiest to use after the fact.

Network libraries depend on the types of network protocols you allow to conect to your SQL Server and are generally available in the Network setup. DB libraries are the client...

Depends on how it is removed. If done with a truncate the answer is no, only the poitner in sysindexes to the first page is set to 0 (invalid). If...

The reason is due to the storing of the execution plan. If you have both in the same SP like that then you will only save the first execution plan...

I have seen this before but forget the exact details on other areas. However if someone builds and application using DMO to connect to the server and does set the...

You didn't happen to name the SP 'sp_' as the prefix did you? If so it will always try to find in master before local and the cachemiss will occurr.

Actually SSN will be fine but should be CHAR not VARCHAR as it is fixed in length and format.

It will in many cases be but will be an index scan...

Finnal numbers are not yet available. I assume thou will be close on both counts to what 2000 has been thou.

If you are going to use this in an SP and these are the only options the this will give best bang.

CREATE PROC ip_OptRun;1

 @a_or_b AS char(1)

 @row_id AS int

AS

SET NOCOUNT ON

If ...

For the given scenario the answer is no.

Look at the IsNull function.

Using Profiler wathc what is happening on those machines and compare with the same activity on one that is working. Might give some insight. Right off I haven't seen this...

Verify that the user has the same object and db permission on that server as the rest. Espeically make sure it hasn't been given dbo status somehow.

You will have to use sp_OQCreate to open a file system object and write in the data unless you are using DTS.