Be careful about using live data to generate test data without some obfuscation. If you have personal data (names, phones, SSNs, etc.) you should change these around somehow. Make some...

I haven't done property management, but I did some work with education and we had a very free slowing type of architecture as well.

We used to handle this two...

I hear from a lot of companies and some are pretty good abourt training their people and helping them keep current IF they are using those technologies. If they're not,...

Being in the US working for UK, I think the UK is doing a bit better right now in raw numbers.

I think offshoring will still happen, but it's not a...

For a manager, an MBA would be better, in my opinion. I don't think a CS degree matters that much for any position in IT. I've never given any major...

Can you provide the error? Also, can you try to break up the steps you are taking in your process? You've run together a number of steps into one sentence...

I like Sergiy's copy/drop/rename solution if it works. sometimes it's much quicker to work with inserts than deletes.

If that last suggestion works, it would be amazing to me. It shouldn't matter, other than forcing a new execution plan. But if the optimum plan is chosen, then it...

Which 3rd party utility do you have? Some take the place of the native backup, Some don't.

The native backup utility works great and is nearly flawless. Some of the third...

Do you mean that you changed the Windows account in AD and the SQL account did not change?

The SQL accounts are linked by SID, but the name is also stored....

This (http://support.microsoft.com/kb/281574) seems to imply that it should be the retail version if you upgraded.

I would at the very least set an alert for the day before expiration and be...

Do you mean 3 errors in one batch or transaction? I believe only the last one will be returned with the alert. Not sure of a way to get around...

IF it's a number, you might need to CAST it as a character string as well before combining it with a plus (+) and the zeros.

Are you saying that you are moving files as in data files to new filegroups? Or are you talking about data?

It's not clear exactly what your package is supposed to...

Each client has multiple transactions, I'm assuming, so that's why you get more values.

You could select the types, but use the MAX( date), group by the owner_id, and that should...