Nice article,

However, would you mind specifying on which versions of Sql Server this works? If this works only on Sql Server 2000, and that is your target platform, you might...

There are some validations that need to be done according to some of the fields present in the card record.

The non-clustered index was card id.

After I found the card...

select * from card where serialnumber between @fromserial and @toserial and purchaseorderid = @poid.

updates are done using the primary key but only after the cardid is acquired by its serial...

Here it is:

CREATE TABLE [dbo].[Card] (

[CardId] [bigint] IDENTITY (1, 1) NOT NULL ,

[SerialNumber] [nvarchar] (50) NOT NULL ,

[StatusId] [smallint] NOT NULL ,

[PurchaseOrderId] [int] NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Card]...

Hi Chiraq,

Thanks for your help. My varchar column never changes. Furthermore, I tried both cases to see which is faster (varchar column and autonumber PK column as clustered index). Having...

If you mean by "If the values in this column will frequently change" that I would update this column, then the column can be safely assumed to be read only.

Nice article. I'll be waiting for you next articles on the topic to get a glimpse into the lower level details and implementation of the concepts described esp: Horizontal...