I'm considering porting a system currently in Sybase/UNIX to MS SQL
Server/NT due to a 16 subquery limitation in Sybase (need about 40 or
50). Sybase won't be fixing it until 12.0. Unfortunately there is no
other way to write the query and without having major performance
The database is over 100 GB and growing. I know MS says they can
handle a terabyte but what have you experienced with databases this
size in terms of perforamance? Any other problems with large DB's?