I recently attached a SQl server 2005 or earlier(not sure)file to a MSSQl 2008 server.
Is this OK??
Everything seems fine but when i query the database for even 100 records it takes around 90 seconds.
This is coz the database has columns that are 'computed'. What went wrong?? Works fine on the machine with the older version of SQl installed.
When ever i include these columns with 'computed' the query takes forever..