• Without knowing more about what constitutes a StockItem, it's hard to say. However this:
    [Description1] [varchar](255) NOT NULL,
    [Description2] [varchar](255) NULL,[Description2] [varchar](255) NULL,
    [Description3] [varchar](255) NULL,

    Absolutely freaks me out. That's very much an indication of a place where we can do some normalization to arrive at a better database design.
    It's possible that you need to have another table (or probably tables) that let's you define the attributes of distinct types of StockItems, but it's hard to say without knowing more about the requirements.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning