FYI, the username issue should be fixed soon. The front end devs have finally written some code to generate unique user names and handle the db errors if they insert...

I don't think I've ever had SSMS crash on me either. If that's your biggest complaint, I'd suggest you look into tracing it down. YOu might have something as simple...

If you only have 2% free space, then you're running out of space. You need to add more space, not shrink.

And you will need more disk space. There's no magic...

Your question doesn't make a lot of sense. You'll need to elaborate about what you mean?

"doing installation before installation" doesn't make sense.

I've done both, sticking with Windows only logins if possible for users as this ensures that users who leave, or are added, to the company get the proper security permissions.

Same size as the original when backed up.

It depends on your environment. You have to work with the clients of the database to decide when a good time for them is.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30922/

What is the error?

Do you have free space in the log or the data files? If the log, it might be that there are virtual log files within your log that are near...

1) The only effect is that the processor is shared among the instances.

2. Yes, the instances are serarate. They both have a master db, and they can both have a...

If you are looking for information on all tasks in SSIS, why not go to Books Online?

Easy to say all of it, but sometimes you need to make choices, especially with encryption. Doing the whole database can have a detrimental effect on performance.

You are not making sense in what you're describing.

Which user? The way you wrote it doesn't let me know what exactly you are doing. You need to provide more...

I have heard a few times that SQL Serer is really lacking. Yet is sells amazingly well and has met almost every need that I've ever had. Can it be...

You can set the identity to increment by 2. Then you can have it compute a column with the EMP and the numerical value. That will give you what you...