Browse by Tags

Tagged Content List
  • Blog Post: 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 PK_ID PRIMARY KEY (ID) ...
  • Blog Post: 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), but hopefully we also had made an additional...
Page 1 of 1 (2 items)