Agree with above. Consolidate to 1 if you can, but keep a backup. Use log shipping, etc. to get your data moved to the second server and ready in case...

You can't be assured that no one is working in temp as ORDER BY, GROUP BY, etc. all use tempdb.

Use the shrink files from EM (database, right click, all tasks,...

charindex and/or patindex. Use them to find test (numericl position), then get the numerical position of the next \ wher you want to stop. Use patindex again, but a starting...

Advantages:

It's more scalable and should handle larger loads. Access/Fox is a file based system, so it's like everyone is using not only the same files, like people sharing an Excel...

Got to look in the mirror. I know it's been me in the past a few times

Good points, and I agree that's the case in many places. But are you sure you're code is better than someone elses?

I think this is valid in some cases, there...

I was wondering how many people might not know. I'd hope if you came here you'd have seen it, but maybe not.

Hopefully they...

Steve,

You can have it if you want. It's sitting under my desk, but for the shipping cost, you could probably get one on ebay that would beat it's socks off.

I...

I tend to agree that technology is exasterbating the problem. The big reason is that it makes it easier to collect more and more information at a greater level of...

No one cares

Glad you liked it. That's half of our aim here.

Tend to agree with that. My 13 yr old is on the way down

Just speculation. No word that things will be ported, but if they're moving the XBOX there, and with it DirectX and some of the other interfaces, maybe they will.

Search the site, there might be something there. NGSSoftware has some tools as well, that might help you.

good advice above, but bits cannot be used in GROUP BY and some other operations. Check BOL for the restrictions and be sure they will not byte you. One note,...