The surrogate keys will help to keep every rows unique, right? This can be done with the current identity column I have in place. Therefore, ...

I forgot to add that I am in a process of migrating from SQL2000 to SQL2005. I want to see if I can move databases from server sql2000...

Wow, I think my post launched an interesting story.

We might facing a lot of fragmentation, see the result of the analyze.

Volume Data (D:)

Volume size...

The table seems to be not too fragmented:

DBCC SHOWCONTIG scanning 'REP_table' table...

Table: 'REP_table' (672057480); index ID: 0, database ID: 10

TABLE level scan performed.

- Pages Scanned................................: 519723

- Extents Scanned..............................: 64974

- Extent...

One more thing. This table is truncated and repopulated on a weekly basis. No insert/delete or update are done to the table after the load. How the...

Ok, I understand now.

How can I see if my table is fragmented and how I can defrag? what about the disk file fragmentation, how I can defrag it?

Thanks SQLGuru...

Here is the plans cost for both exemple:

************

select * from rep_table with(index(ix_table_dist))

where dist='TYERY'

Bookmark Lookup

Physical operationBookmark Lookup

Logical OperationBookmark Lookup

Estimates row count244,918

Estimated row size ...

What I meant was if I add a Primary Key Constraint, the data will be sort according my key and will not be a heap table anymore.

In a...

Where I can find tthe reporting services report packs on SQL2K?

Thanks

Instead of moving the index from non-clustered to clustered, if I add a primary key on field "ID" to the table, this work?

Thanks

I am new at this place. I will need to dig out how the queries are done on that table. I don't want to jeopardize the all other...

Hello,

We currently don't have clustered index in this table. The table (36 million rows)is truncate on a weekly basis and then repopulated. All indexes are rebuild afterward. ...

Hello GilaMonster,

Here is the information:

rowcount whole table:+/-36000000

expected rowcount return: 244918

CREATE TABLE [dbo].[REP_table] (

[ID] [int] NOT NULL ,

[Qty] [int] NOT NULL ,

[Price] [money] NOT NULL ,

[FPrice] [money] NOT NULL ,

[Fline] [money]...