SQL, Analysis Services & related stories.

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...

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...