Turning into Magento EAV model (http://www.magentocommerce.com/wiki/_media/doc/magento---sample_database_diagram.png?cache=cache), EntityAttributeValue table is splitted in 5 different tables: EntityAttributeValue_datatime, EntityAttributeValue_int, EntityAttributeValue_decimal, EntityAttributeValue_text, EntityAttributeValue_varchar. This solution improve storage but it increase the model...

Hi

A good example of EAV model are e-commerce apps like Magento. They are using an EAV model and duplicate writes to maintain some denormalized tables, they are using EAV for...

Neither int nor char convertions inside the ON sentence will use an index. They are non sargable. Difference can be due to exogenous factors that maybe affect the execution plan....

1. Maintain only usable indexes. You can check which indexes are been used running dmv queries (sys.dm_db_index_operational_stats and sys.dm_db_index_usage_stats)

2. Be sure you don't have significative scan tables: Check profiler and...