Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

February 2010 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

February 2010 - Posts

SQL Server 2008 Service Pack2 announcement and Cumulative Update package releases

First things first, from the followup of SQL_Server_2008_SP2 post here is the good news to the community that SQL Server Release Services announcement about SQL 2008 SP2 release...Microsoft targets release in Q3/CY2010.

Next on the Cumulative Update package releases, ...read from here...

 

SQL Server - SSIS package transformation performance issues, follow up

To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share.

When you see that SQL Server instance throws the error as per above blog post, the amount of memory that can trigger this issue varies for different computers. If the package is really handling huge number of rows ...read more...

 

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

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;