In my projects sofar i've have created configuration files in my packages. I made one development folder and a production folder. In this case i only have to pass the...

Well, couple of weeks later. The investigation is now focussed on deleting the statistics on SQL Server 2000. First i have to find out whether the statistics can be scripted?...

Yes, I did make the example overly simplified because I just wanted to trigger an ah-ha! moment. The article was already running long without getting into a lot of...

ahh i get it.. thanx

I need to use multiple columns in the hashindex and so use a checksum over hashbytes such as:

checksum(hashbytes('MD5', column1), hashbytes('MD5',column2)) - this works pretty well but is still not 100%...

I have not read the article in detail, so correct me if i'm wrong, but the hashbytes accepts only one column (of one type character) and in this article the...

80 non clustered indexes+ 1 clustered index + 81 statisics for the indexes + 88 left over statistics = 250.

Okay my initial description was a bit fuzzy. I opened this...

Thanx for your replies. It's hard answering all your remarks and questions.

Upgrading to SQL2K8 is currently not an option for the vendor. I'm still thinking about deleting statistics which...

Don't know. Why do you ask?

Why should ik focus on the indexes? The indexes are advised by the vendor. When i try to change the indexes i will danger the support from the vendor....

thnx but this case is about SQL Server 2000 and it's not using dmv's. I found out that SQL server 2000 index slots are used by statistics, i read on...

Thnx all for your replies. The case is that the supplier of the software wants to add indexes but can't because the 'slots' are being used by statistics (he said)....

Thnx for your reply,

currently we are not doing anything 😉 Until we are absolutely sure that it will not effect performance (100 consurrent users). We want to drop statistics and...

Company wants to update the software and more Foreign keys are added. These Foreign keys will be indexed. I now know more about this issue: There are about 80 indexes...

Thnx for your answers. Your answers are confirming what i was thinking. I wasn't quite clear about XML and varchar. We extract specific fields out of XML messages and put...