Database Suggestions
Database Suggestions
Use stored procedures where possible.
Let SQL do the work where appropriate.
Learn your Query Optimizer
Use Indices Appropriately (INDEX=…)
Have Enough RAM to Store Your Databases, Indices and Have Extra
Identity Columns & @@identity
Ordering Your WHERE Clause
Previous slide
Next slide
Back to first slide
View graphic version
Home
Directions
Quotes
Photos
CF Conf Central