Based on this you would want your clusered index on another column or columns and if you are using the identity column in joins you may want a non-clustered index...

Have you analyzed the code to see if the cursor can be replaced with something set-based?  It sounds tp me like the cursor is starting some tasks that do not...

The DB is in Simple recovery model so the log can't be backed up.

I do not run Vista, mainly because I do not have a PC that would run Vista.  I also don't think Vista really adds anything I need.  I could care...

Is CLR Integration enabled?  If it is you could write an assembly that accesses the remote data and use the assmbly to create a Table Valued function you can then...

Have removed the last change you made to the report?  Have you tried using debug mode and running the report?

I thought this was an excellent article with a simple solution to a complex problem.  There are definitely possibilities for performance imporvement, but the solution supplied to the problem was...

If you have this option it is the way to go.  Are the db's all on the same server?

I would write db specific sp's and then have a master sp...

I'm not sure how this will affect overall performance, but I believe it will use the same execution plan regardless.  You could union the 2 tables and since the clustered...

Here is the T-SQL for this RESTORE DATABASE NORTH

   FROM DISK = 'C:\SQL\Backup\North.bak'

   WITH MOVE 'NORTH_Data' TO 'D:\SQL\Data\North_Data.mdf',

        MOVE 'NORTH_Log' TO 'E:\SQL\Log\North_Log.ldf'

For dull disclosure I copied this from this...

Some other issues you may need to address are:  does revoking delete allow the user to run a truncate?  If the user has all rights except delete they can still run a drop...

It would appear that Sql Server is using different execution plans for the SP and the query.  Chekck the the execution plans to see what SQL Server is doing, then...

Just to clarify what Ninja is saying.  He means run the code that Deepak provided on another server or to a new database and then import the deleted table from...

I have taken several MS classes at New Horizons and have learned a lot, but never gone done the certification path.  I have taken some practices tests and seen many...

One method to allow you to re-use the stored procedure which is relying on the temp table is to check for the existence of the temp table at the top...