Browse by Tags

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure
01 February 10 03:58 PM | ssqa.net | with no comments

A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; ...more from here;

Filed under: sql server, performance, error log, integration services, ssis package, low memory, export, import

Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)
11 February 09 02:15 PM | ssqa.net | with no comments

The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...

Filed under: sql server, 2008, 2005, best practices, integration services, dts, ssis package, 2000, backward compatibility

Data Warehouse Scalability Features in SQL Server 2008
07 March 08 01:44 PM | ssqa.net | 1 comment(s)

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within...

Filed under: sql server, 2008, reporting services, blogs, new, technet, ssis, management studio, data warehousing, ssrs, features, documentation, analysis services, ssas, integration services