So having no cluster Indexs on any tables and a few non-cluster is normal? i have a really small set of dbs to look at so just trying to learn from what i can look at?
Oooooooh, no clustered indexes at all
? That's a whole different ballgame. No, that's not common, and is not really great design except in specific circumstances where a heap will give you better performance. Those are generally rather rare, particularly in SQL Server where most of its optimization relies on the clustered indexing.
It sounds like it's a generic build that happens to currently reside on SQL Server. I've heard rumors of other particular systems handling heaps with nc indexes behaving much cleaner (like MySQL) but I can't speak to that directly.
Schema customization from the front end (not sure what you mean)? the only thing i can think of like that (which is really not like it at all im sure) is that they don't use temp tables for anything and have normal tables instead (really not sure how normal that is..or would work with high lvls of users)
Sorry, forgot how new you were, apologies for the short form of that comment. A number of vendors, in their attempts to make things as easy as possible for their users, will allow for customization from the front end. Usually there's a table in the database somewhere like "ProductCustom" that they'll create/alter columns for the front end.
It's not great design but it does keep the users out of the database for customization.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake. For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally TablesTwitter: @AnyWayDBA