Primary Key Column

Does position of primary key column in a table has impact on perfromance ? I
have always used first column(or columns) for primary key. I am looking at a
system right now which has primary keys defined in the middle or end of
table. Does it impact performance ?
Any help is appreciated. Thanks.
No impact. What has impact is what indexes you have and how they are defined. And remember that a PK
definition creates a unique index (by default as a clustered index).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"B2" <B2@.discussions.microsoft.com> wrote in message
news:D6C7E1FB-CAAF-4275-9FBF-F5C6F235B2E0@.microsoft.com...
> Does position of primary key column in a table has impact on perfromance ? I
> have always used first column(or columns) for primary key. I am looking at a
> system right now which has primary keys defined in the middle or end of
> table. Does it impact performance ?
> Any help is appreciated. Thanks.
>

Primary Key Column

Does position of primary key column in a table has impact on perfromance ? I
have always used first column(or columns) for primary key. I am looking at a
system right now which has primary keys defined in the middle or end of
table. Does it impact performance ?
Any help is appreciated. Thanks.No impact. What has impact is what indexes you have and how they are defined. And remember that a PK
definition creates a unique index (by default as a clustered index).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"B2" <B2@.discussions.microsoft.com> wrote in message
news:D6C7E1FB-CAAF-4275-9FBF-F5C6F235B2E0@.microsoft.com...
> Does position of primary key column in a table has impact on perfromance ? I
> have always used first column(or columns) for primary key. I am looking at a
> system right now which has primary keys defined in the middle or end of
> table. Does it impact performance ?
> Any help is appreciated. Thanks.
>

Primary Key Column

Does position of primary key column in a table has impact on perfromance ? I
have always used first column(or columns) for primary key. I am looking at a
system right now which has primary keys defined in the middle or end of
table. Does it impact performance ?
Any help is appreciated. Thanks.No impact. What has impact is what indexes you have and how they are defined
. And remember that a PK
definition creates a unique index (by default as a clustered index).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"B2" <B2@.discussions.microsoft.com> wrote in message
news:D6C7E1FB-CAAF-4275-9FBF-F5C6F235B2E0@.microsoft.com...
> Does position of primary key column in a table has impact on perfromance ?
I
> have always used first column(or columns) for primary key. I am looking at
a
> system right now which has primary keys defined in the middle or end of
> table. Does it impact performance ?
> Any help is appreciated. Thanks.
>

Previewing a report does not display the text fields at the correct position

Hi NG,
I've got a report in my report project in that the fields' position is
changed when previewing.
Have anybody recognized similar problems?On Apr 30, 6:16 am, "Martin Trabold" <m_trab...@.yahoo.de> wrote:
> Hi NG,
> I've got a report in my report project in that the fields' position is
> changed when previewing.
> Have anybody recognized similar problems?
Could you explain further. Do you mean fields changed order (i.e.,
Col1, Col2, Col4, Col3)? Or do you mean changed do to report borders
or page settings?
Enrique Martinez
Sr. Software Consultant