Here is the design of the Polygon table. The one supporting the cursor:

CREATE TABLE [dbo].[Polygon] (

 [MSLINK] [int] IDENTITY (1, 1) NOT NULL ,

 [CLASSTYPE] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [SYSTEMID] [varchar]...

The only index is the one created at the bottom of the SP.

CREATE CLUSTERED INDEX IX_PolygonTileIndex_TileIndex ON PolygonTileIndex (TIX, TIY)

I guess given that I am now truncating the table...

Thanks for the input.

I will try truncating the table in place of the drop and recreate this morning.

The drop and create is not an issue as this is not...

Thanks for the thoughts. Could you please elaborate a little more on the following comment. I'm looking specifically for comments around database impacts/benefits.

The benefit of using the n+1 cluster where...

Thank you for the information and we will try the OSQL you have provided.

Yesterday, using ISQL, we were trying the following ISQL -U domain\id -P password and it would not...