This did the trick. Thank you so much.

i had unfairly ruled it out. i will give it a try and see if ig works.

Thank you.

There is a function fnOpsUsr that we are using to enforce default constraints. Now ae want to update the function. The function can not be modified without dropping and recreating...

There is a function fnOpsUsr that we are using to enforce default constraints. Now ae want to update the function. The function can not be modified without dropping and recreating...

Thank you very much.

I would say you have assisted me a lot. I will re-consider my indexes. I am also going to come up with the bench mark queries...

Hi Christopher,

I would like to start by thanking for taking your time to have a look.

I have a few question though regarding the choices you have made. I feel that...

Hi,

Apologies about the old code. We are still supporting sql2000 and i would appreciate it if we create the indexes in a format that is also sql2000 compatible. I see...

Below is the table generation script:

CREATE TABLE [dbo].[Vessel](

[ID] [dmVessel] NOT NULL,

[Name] [dmName] NOT NULL,

[SrchName] [dmName] NOT NULL,

[NameType] [dmNameType] NOT NULL,

[ExName1] [dmName] NULL,

[ExName1Srch] [dmName] NULL,

[LloydsNumber] [dmLRNo] NULL,

[MktStatus] [dmMktStatus] NULL,

[TradingStatus] [dmTradingStatus] NOT...

Thanks Paul for the detailed explanation. Like Gail said, a book with everything in one place will be good.

I will apply the recommended changes and update you.

This definitely has given me more insight. I will review my indexes and seeork. I had a misconception. I thought that the clustered index is always the first choice for...

Hi

Thanks for the response. I was trying to organize my code so that it can be easier to read, unfortunately the center tag did not work out as i wanted....

Hi Florian,

Thank you very much for the two links. They have already given me a lot of insight. I will definitely change the way i specify my problems.

🙂