insert select works well.

The IN function expands to a series of ORs for each value. Performance depends on how many you have and how you are indexed, as well as the data distribution.

you...

While I'm sure you'd enjoy going home, you should change the password. Finding a DBA or even moving to another workstation is fairly inefficient.

First backup to separate drives than you store data on, or script out a copy immediately.

Depending on size, I'd run a full every night and differentials in the middle to...

Did you lose a disk or move things around? It looks like either you have a bad disk, or it moved. Is the error log back there?

Also, check the...

Interesting subjects. And thanks for the laughs. Glad I didn't forward that beer one on to Tony.

My Mom gets all kinds of stuff from friends and sends it on. I'm...

I think all of us have done some of this with root cause analysis or backtracking through logs to find out what happened. Data has an interesting aspect in that...

Are you connecting via named pipes? Check your client config.

You want to have a specific port set for each instance and then use that in your registration on the client....

It sounds like it just flaked out. AFAIK, the restore with standby should not take much longer than a restore with norecovery.

Perhaps you have transactions open in the secondary database...

That's amazing. I would think that if you needed help they'd call someone in anytime day or night. However you did say they were there on request. At least that's...

You can search information_schema.columns in both systems, order by name, and the compare to see which columns are in the tables, or which ones aren't.

Then you can use an ALTER...

Don't cross post: http://www.sqlservercentral.com/Forums/Topic598854-361-1.aspx?Update=1

There isn't a set hardware configuration.

How are you partitioning? What is the purpose? There isn't a way to answer a general question like this because it depends on how...

I think you have some HTML that's being seen as code and not a post.

If you want to delete everything after say, [*---, then you search for that in charindex,...

You would need to run a tail log backup. The problem is I'm not sure how you will run one if you deleted the MDF.

You can recover to 3:00 using...