Use caution when upgrading SQL 2008 CTP SSIS packages to RC0
A ran across a bit of a problem when upgrading my SQL 2008 CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0. Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages. Because of this when I edit all of the script tasks within my SSIS package the […]
SQL Server 2008 RC 0 Released
Microsoft has just released SQL Server 2008 RC 0. This release should be pretty close to the final version expected out later this year. Denny
Article: SQL Server memory configurations for procedure cache and buffer cache
To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you’re using, whether it’s x86, x64 or Itanium and the amount of memory allocated to the SQL Server instance. I talk about how the system configures memory and how it allocates the amount of buffer and procedure cache that’s available.
SQL 2005 Internal Query Error 8623 still unfixed
Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.