PAD_INDEX : activating or not ?

Hi all,

On SQL Server 7 SP4.

3 tables with about 100 000 rows each one, frequently updated.
1 clustered index on primary key, and 2 non clustered index on columns used by JOIN and by queries.

Fillfactor for index : 90.
PAD_INDEX : not activated.

I have some deadlocks problems, probably due to index pages and key locking (as precised in error log). Is it possible that the cause of that is splitting index pages while UPDATE ?

May I activate PAD_INDEX to solve part of this problem ?

Thanks for any helpIt's a performance issue thing, I don't think that's your problem

http://www.sql-server-performance.com/oltp_performance.asp|||Well, the nature of deadlocks has NOTHING to do with performance, thus cannot be fixed by recommendations given in the link. The only applicable advice which is not even in the section implied is to keep your transactions short. This will minimize the possibility of deadlocks, but will not eliminate them. As you all know, it deals with object access order, and should be addressed accordingly, by examining all possible transactions involving the same set of objects in reverse order.|||Thanks all, I'm going to have a look at it.|||pad index is really not neccesary. i have chased this guy down many roads
i even had extended conversations with kimberly tripp and kalen delaney on this and everyone i have talked to has told me that pad index is just not gonna provide any real advantage.

Package MajorVersion and MinorVersion, when do they change?

HI, I am wondering when those system variables change. I just cannot see when these are updated. Also, VersionComment, whta is the purpose of this?

Thank you,

Ccote

You change them. For your own version control system.|||

Thanks, is there a way to change those properties via VSS? Or maybe I do not unerstand.

Ccote

|||

No, you would update the values on the properties through BIDS. It is so you can set your own version numbers.

|||

OK I saw it, thanks! What would be the difference (or usage of) between Major and Minor version? And also, is there a way to set these properties via a script task? Open all packages and set properties?

Thanks again!

Ccote

|||

ccote wrote:

OK I saw it, thanks! What would be the difference (or usage of) between Major and Minor version? And also, is there a way to set these properties via a script task? Open all packages and set properties?

Thanks again!

Ccote

"Major" version might be a complete overhaul of logic. Perhaps you've restructured the way totals are calculated and are now performing via new business rules.

"Minor" version might be a minor change -- a where clause addition, fix a typo, etc...

In the end, it's up to you.|||

ccote wrote:

OK I saw it, thanks! What would be the difference (or usage of) between Major and Minor version? And also, is there a way to set these properties via a script task? Open all packages and set properties?

Thanks again!

Ccote

You can use the SSIS API to load packages and set the properties, then save the packages again, if you want to automate the process.

|||

Ok thanks guys!

Package configuration

Hi all of us,

I'm looking any .dtsconfig file as sample for my first package configuration. I've got ssis packages which might be updated on development and then moved to production. First of all, I'd like dynamically change the connections but I don't know exactly how to do that. I'm taking a look on the wizard but when I choose a Sql Server request me a table.

Any sample or link for that would be welcomed!

TIA

Ok, I begin to understand something...

<?xml version="1.0" ?>

- <DTSConfiguration>

- <DTSConfigurationHeading>

<DTSConfigurationFileInfo GeneratedBy="REDCAM\AdminSql" GeneratedFromPackageName="TestMan_PreProduccionCargaBuildPaso" GeneratedFromPackageID="{2E73D76E-4AAF-4BEF-BDE6-379C90193FB1}" GeneratedDate="10/17/2006 1:10:05 PM" />

</DTSConfigurationHeading>

- <Configuration ConfiguredType="Property" Path="\Package.Connections[Excel Connection Manager].Properties[ExcelFilePath]" ValueType="String">

<ConfiguredValue>\\srvaa8\Ficheros\ssis\BuildPasos.xls</ConfiguredValue>

</Configuration>

- <Configuration ConfiguredType="Property" Path="\Package.Variables[User::RutaFicheroCarga].Properties[Value]" ValueType="String">

<ConfiguredValue>\\srvaa8\Ficheros\ssis\</ConfiguredValue>

</Configuration>

- <Configuration ConfiguredType="Property" Path="\Package.Variables[User::RutaFicheroError].Properties[Value]" ValueType="String">

<ConfiguredValue>\\srvaa8\ficheros\TestMan\Produccion\SinDatosPrevios\</ConfiguredValue>

</Configuration>

- <Configuration ConfiguredType="Property" Path="\Package.Properties[VersionComments]" ValueType="String">

<ConfiguredValue />

</Configuration>

</DTSConfiguration>

My question is how to set different values to my file? How to tell the .dtsx that uses this file or not?

TIA again,

|||

Ok, I'm sorry for this mess of the post, I'm awaring of things as time goes by...

I've seen that is possible do the same using a table but my wonder now is the following: is it possible use the same table for more than one package? I guess not but...

Thanks again for your patience,