Jason Shadonix (1/19/2010)
Just out of curiosity, has anyone ever run up against the 250 index limit in SQL 2005. I can't imagine ever needing that many in our environment.Perhaps if you have a very wide read-only table I can see it, but even that's a stretch.
Even I want to ask the same question. Had anybody seen these many indexes on a table ? Other question would be if we have these many indexes on a single table then the performance of read / write transaction would be slow or good ?
How about managing space for all these indexes would take if its on a large table ?
Any one please ?
SQL DBA.