First, do you mean backup files? You haven't provided much information about specifically what is happening.

Dump is an old term, and a backup is the new term for a copy...

We don't have unions. If you want a higher salary, ask for it, negotiate for it. If you don't ask, you won't get it. And if you feel you're underpaid,...

If we're going to have constantly shifting names, I'm going to get confused quickly.

We're not hiring for now, at least not here at SSC. Not sure about the rest of Red Gate, but you'd have to move to the UK.

I've taken jobs with...

The submission to the database is pretty short. Why not just shoot the records over to the db after each question? That way you've saved data if the app crashes,...

The XLS has been updated along with new builds.

If you are speaking I/O, there shouldn't be a negative. There is less data to retrieve (because of compression) and so there is less physical I/O. As mentioned by Grant,...

Even if you had the same user name on that new instance, the mapping to the database might not be correct as it's by SID, not name. You can use...

I assume you mean other than calling a sproc 5, 10, or 20 times? I'd go with a comma list then, but test it against just 20 calls.

I've seen products before that would connect Exchange to SQL, but I'm not sure about OoO info. That sounds more like a setting for a user, and you'd need an...

Instances use a range to dynamically select a port. You can get the port from the error log of the instance when it starts up, or you can set...

Do you mean those objects created out of order? Or are you trying to find objects that are dependent on something that hasn't been created?

This isn't easy to figure out,...

However you wouldn't build indexes for every query. I would think you would start with the columns in PKs and FKs first, if you haven't explicitly declared those or set...

Richard (7/29/2009)

---

I could not find a chair that really expressed me so I built one.

See it here

It is from a 2007 Corvette. The recline still works and it is...

That's more along the lines of what I'd expect.

The memory usage in SQL Server can be a little strange. I know there are certain things that might need contiguous references,...