[dba-SQLServer] Quotes in delimited data

Not having seen the data, but still willing to shoot my mouth off...

I would be sorely tempted to break this table into several, along the
lines of likelihood-of-search. Put the most-likely fields in T1 and the
second-most-likely in T2, and so on, with 1:1 joins so you could
optimize the searches, joining only when you have to.

Second, I would seriously consider putting all those booleans into a big
bit-mapped field so you could AND and OR and XOR and so on.

Just my $.02....

Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: Monday, September 13, 2004 11:19 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Quotes in delimited data


OK, now for a 660 field table?

;-)

John W. Colby
www.ColbyConsulting.com