I have recently decided to make the change from Microsoft access to SQL Server believing that it's a bigger faster beast with better parameterized queries and triggers and all that. BUT.I have some client data that I imported from their original paradox files.The invoice lineitem file contains over 1 milliion records.When I open this table in access and click show last record, the record is displayed in about 1 or 2 seconds.I used the upsize to SQL Server tool in Access to shift my data into SQL Server.When I use the Express Mangagement tool to open the same table and say show me the last record, it takes 17 minutes.I admit that most numeric data types have been translated to floats, so that's probably not good.But I cant alter them from floats to numeric or decimals using the table design tool.Do the conversion anomalies make up the whole reason why SQL Server seems so incredibly SLOW! ?
It sounds like you don't have the proper indexes in place.
AND it is a bit more difficult to index float values.
You 'should' not have any difficulty in changing the datatype from float to a different numeric datatype using the design tool.
|||
do not open the table from SSMS... use select query from Query Analyser. and also as Arnie said it seems that the table is a heap (do not have clutered index) create index and update the statistics.
Madhu
No comments:
Post a Comment