- Import external data
- Crunch the data using several stored procedures
- .NET presentation app displays it
We would like to speed this up and have done a lot tuning. We are in a unique position where we really don't care about loosing data -- because all data is refreshed each time the forecast is run. Is there anything we can do in SQL Server to take advantage of the fact that our data has absolutely no value beyond the current session? I assume there are many things SQL Server does that is meant to protect data loss. Can we disable anything to speed things up?
- Consider dropping the indexes prior to the import of the external data and then rebuild the indexes.
- Consider dropping any unneeded indexes.
- Consider only appending only 'new' data to as compared all of the data each time the data is loaded.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.