Or you can store as varchar. Are these part numbers or something? If you don't do addition, or even if you do, I might store as character data.

I can see your argument, but the question doesn't ever come close to specifying columns. It specifies values and shows a query on one column.

This is to learn and for...

Is the user's login mapped correctly as well?

Read baarf and think about your environment. If you have lots of reads, I'd go with R1 or R10 for data, get the speed up there. You definitely want separate...

You can change it manually, it would take time, but it's probably the best way to do this. If it's not every table, and a common pattern, a script could...

This is a complicated subject and we can't necessarily give you a complete explanation on encryption. I'd suggest you read in BOL and articles on building encryption into an application....

Agree with above. Do it after.

Wither you have to pass all values, or unpassed values need defaults in the stored procedure definition.

You can specify specific parameters as

exec mystoredproc @param2 = 4, @param4 = 65

But if...

This is an application problem. You probably need to manually insert the admin record into both tables from EM (Enterprise Manager) or QA (Query analyzer)

I'm not sure there are any great dedicated resources. The books are a good place to start, applying the concepts from them to your environment.

you can also try sqlis.com

It depends.

clustered index better for range scans, nonclustered better for specific rows, covering always good.

I'd do the first listed above, but script out the tables and dependencies from SSMS, modify the scripts, and then run them to alter the tables.

If you alter a table...

The advice above is correct. As far as I know, only SQL Prompt from Red GATE can do this in 2005.

If you stopped the server, you should be alright as mentioned above.

What you did makes sense with that many databases and this should have speeded up the process. The thing...

Autogrows can slow performance and fragment the file on disk. The impact depends on your system.

you should be monitoring space, keeping enough pad in the files for 3-6 months, and...