I agree with Jeff. I'd do it like you're doing it.

While I agree with Jeff that you might want to trust the DBA, I know that some of my sysadmins were much better at tuning Windows than me and...

While I don't like SELECT * in code, I'm not sure it's less efficient. I'd like to know why. I always learned that it resolved the column list at compile...

Optimum is hard to determine. It's somewhat a philosophical debate on how you want to handle things.

Personally I don't like linked servers. Possible security holes could be used for other...

I was thinking that the compression could aid the solar hot water in providing radiant heat. The cold air could be used for cooling in the summer.

I still agree the...

Hadn't thought about that, but it would be nice if you could use that thermal energy somehow. Maybe incorporate into some heating/cooling application?

Please don't cross post. We check all forums.

http://www.sqlservercentral.com/Forums/Topic436403-5-1.aspx

Yes, partitioning can easy keep data separated, usually by dates, but could be by other values, and let you add rows to "part" of the table without affecting the other...

Haven't really noticed this, but I haven't messed with the system tables much. Does the login have SA rights? Are there any problems?

My guess is that it's a display issue...

If the old and new are on the same server, the backup and restore will be easy. I'd recommend you do an EXECUTE AS (look up), to allow people with...

I wish, but no. The threading models are vastly different and Microsoft has declined to rewrite it for a *Nix.

You can run Windows under VMWare or another virtualization technology...

You can have multiple columns in your primary key as well, so it could be a compound key instead of a single column.

First, please post in the appropriate forum for your version. I'll move this to the 2005 forums for now.

Second, search for sp_help_revlogin and you can use that to move logins....

Look up sp_change_users_login as well. you might need to relink the login and user.

I'd avoid these if you can. If you really need to store something, use a permanent table and store it in there. Even if you link it to a SPID...