I'm not sure what you are asking here. What is a "condition" by your thinking and what relation does that have for files or filegroups?

Also, please don't write in large...

Re: xp_cmdshell. It's not so much that people are brainwashed as it's an open-ended shell, which can be a security risk. You can minimize it, and perhaps mitigate any major...

Interesting thoughts.

I think SSIS is useful, but it has a high bar of effort to get things done. The "code reuse" comes from cut/pasting, from what I've seen, into a...

Thanks, and hope everything goes smooth for you this weekend.

Set up a view in Database A into Database B that looks for the names. Something like

create view AgencyNames

as

select name, id

from databaseb.dbo.AgencyNames

Now write a query in Database A (or...

Set up a second connection to the second database. IF you are wanting to combine them, it's more complicated. One way is to get a linked server between the instances...

2GB may or may not work, it's all about performance. Depends on the access patterns and load for data. If you can accept the disk delays, it's fine. I might...

Snow. Last Friday of the year

I work for Red Gate, and Data Compare makes this easy if you are moving lots of data.

However the other thing you can do is export the data with bcp...

I have been hanging with the kids. That's how my daughter says it to me. "Oh Em Gee, Dad"

Oh. Em. Gee.

Are you guys having a deep technical discussion on some type of performance testing? Shouldn't that be a thread somewhere else besides The Thread?

Nicknames do have to be unique.

SSIS typically runs as a job under Agent.

If an Agent job issues a BACKUP DATABASE, it is no different than if you issue it from SSMS. SQL Server still...

We will publish the list of mentors after the applications close. We want this to be about mentees and mentoring, not about the mentors. At least, that's this part of...

Dan.Humphries (4/21/2011)

---

I like your responce to a bad situation. I often feal bad for the ticket agent in airports as they get screamed at. I think people forget...