[dba-SQLServer]index limits

Francisco H Tapia my.lists at verizon.net
Mon Apr 14 18:32:07 CDT 2003


Susan,
   in good humor, :), You remember that book you co-authored right, SQL:
>From Access to Sql Server?, Access Data Projects are nothing more than Code,
and Gui that hook into Sql Server, all the tables, views, sprocs (stored
procedures) are held in a Sql Server Engine (be it Sql 7/2000/MSDE 1/2).
And you can tell Rabit that caffenie is a good replacement for Vitamin A ;o)
(just brute force!!! :D)

just remember this, just because a little is good, does not mean that a
WHOLE LOT is going to be better, if you find yourself needing 249 indexes in
a table, perhaps it's time to look at normalizing your whole DB :)

-Francisco
http://rcm.netfirms.com

On Monday, April 14, 2003 4:22 PM [GMT-8],
Susan Harkins <harkins at iglou.com> wrote:

: Wow... thanks Franciso -- 249? I'm wondering if this holds for an
: Access project -- I mean the tables are SQL Server, right? Rabbit
: wants to know if rootbeer has vitamin A? :)
:
: Susan H.
:
:
:: Each table can have as many as 249 nonclustered indexes (regardless
:: of how they are created: implicitly with PRIMARY KEY and UNIQUE
:: constraints, or explicitly with CREATE INDEX). Each index can
:: provide access to the data in a different sort order.
:
:
:




More information about the dba-SQLServer mailing list