It's likely that the banks have been using Sybase for a long time and keep upgrading. Also as mentioned above, their software may require it.

Sybase is a good product and...

I'm not 100% sure what is wrong, but when you first install SSMS or SQL Server, there are not connections under Registered Servers. You need to add them yourself.

I'd create...

I agree with Christopher's suggestion. I'd create a table of holidays because these can change from year to year for a company. This way you can join in this table...

How else will you do it other than mapping each table? There's not facility for automatically moving tables to an archive.

Set up a task in DTS for each table, use...

It's probably because they have been working on Sybase for years and see no reason to change. Sybase has been a good product, just not as popular as SQL Server...

If you're hitting it in a table, you'd need to check the data rows.

Go to BOL and get the data type sizes, (ints are 4 bytes, etc) and then you...

Were you shrinking the entire db? (log and data)

Shrinking is not recommended for data files. It disturbs your indexes, creates fragmentation, etc. You shouldn't do this to data files at...

K, image changed

Yeah, maybe bad choice of picture. I knew it was India Indian, but didn't really see something I liked.

The idea wasn't to say the India is right or wrong in...

It's not necessarily that web apps work everywhere, but they're easy and cheap to build and they can work in lots of data entry situations.

Bonding isn't a guarantee. It's insurance and just provides some recourse for those affected by a data loss. It just gives you some measure and it's not perfect. But it...

Very well put, Charles.

I tend to agree with Anders. Most DBAs I know hate sending data out the door, even when the manager is complaining you need to do it. I'd require an...

Actually I think the weakness is a good question. Some of the others are inane. I try to ask questions that make you think, mostly so I can try to...

I'm not a SAN expert, and I really recommend talking to an engineer from your vendor because different SANs work differently, but...

1. Possibly. You don't want this, or I don't....