vertical-partitioning

SQL Server: Any value in vertical partitioning when i'm always going to re-JOIN them?

i'm faced with having to add 64 new columns to table that already had 32 columns. For examples sake: Customers ( CustomerID int Name varchar(50) Address varchar(50) City varchar(50) Region varchar(50) PostalCode varchar(50) Country varchar(2) Telephone varchar(20) ... ...

Converting Paper/PDF forms for web - Normalize, Partition or Wide-Table it?

We'll be converting a fairly long lease application form into a web application for submission via PHP in to a PostgreSQL database. I abide by the maxim "Normalize till it hurts, then denormalize till it works" (Attr:SQLMenace) but as I jump in I figured I'd tap the collective mind. Here is what the paper form currently looks like: ht...