Performance and loading large files...
Just wondered if anybody else has had any similar issues:
I am testing using ISQL against SQL 2005.
Connected to server instance , and cached master , then selected my user database and it cached that database also.
Checked the memory used for ISQLW was up to 232MB :?
So I exited QA and back in again... and happily running at "normal" levels.
Another problem I encountered is I tried to open in Query Analyser our Database creation script - size is 7 MB with over 220,000 lines of code.
And Query Analyser hangs.. unsure what is happening... So killed off ISQLW - disabled SQL prompt and everything back to normal it loads the file and I can execute it.
So in the interim I have switched SQL prompt off, so I can test my scripts.
Overall, I did try earlier versions but it wasn't scalable .. initial testing it does look useable against a larger database (200 + tables) as opposed to using Northwind!