Browse by Tags

• TSQL

• SQL 2000 to SQL 2005 migration: temporary tables reuse issue.

  During the same project the next issue was found: temporary table reuse. Here is an example on “how to reproduce”: USE tempdb GO CREATE PROCEDURE dbo.usp_step_one AS BEGIN CREATE TABLE #temp (ID INT NOT NULL, NUM INT) ALTER TABLE #temp ADD CONSTRAINT Read More... Posted Saturday, April 28, 2007 8:55 PM by Igor Kovalenko | 5 Comments Filed under: SQL Server 2005, TSQL, SQL Server Troubleshooting

• SQL 2000 to 2005 migration: execution plan change issue.

  Last week I was engaged on SQL 2000 to SQL 2005 migration project, and we had identified some issues related to significant changes in execution plans. Before migration we tested the application with using Upgrade Advisor (test passed without any caution), Read More... Posted Saturday, April 28, 2007 8:01 PM by Igor Kovalenko | 11 Comments Filed under: SQL Server 2005, TSQL, SQL Server Troubleshooting