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

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

As all of you know it is possible to query active directory from SQL Server with using ADSI provider as linked server. This solution works fine until you will have a lot of users in active directory. According to best practice guide windows system engineers always configured AD to return no more then...

Let assume you are using Windows Authentication with SQL Server 2005, you've added a new server account for domain group and would like to give it a default schema. The properties window is the same for users and groups but the default schema field is enabled only for user entities. As a result you cannot...

As all of you know Microsoft has made a small problem for all SQL DBA and developers. If you have a database with any of SQL_xxxxx collations (for more details please have a look at the TERTIARY_WEIGHTS() function here ), you will defenetily have a significant problem with index search and ordering performance...