How to Improve performance on partion View? I have partition view that will fetch data by having union all to 9 database tables. All 9 databases have same table and schema structure on same instance. At the background, this tables keep loading new data for every 1 min to all 9 databases through...

I am importing tables from an Excel 2007 file to a SQL 2005 db using SSIS on a x64 Vista machine. I've noticed a significant slowdown (Window freeze, long execution time ) in SSIS package execution when importing data from Excel/Access 2007. Is it normal? I know Microsoft Visual Studio 2005 is not...

I have an application using MSSQL server 2005. While the system is running, I check the task manager and find that it uses 3GB main memory ( the server has 3.5GB ) and Dual core CPU is only 10-15% used in average. However, it is very slow response time. I need some advises to dig out the reason and improve...