Tough Consolidation of Rows

Question

Viewing 15 posts - 16 through 30 (of 33 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

I am pretty sure he is just suffering from heap fragmentation !!!

1 million rows is not supposed to bring the server down even with the subqueries we wrote !!!

My bet is that after he get ANY clustered index in things will change DRAMATICALLY

* Noel

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Well duh!!!

I bet more ram, faster drives and faster/more cpus could help too .

noeld SSC Guru Points: 96590 More actions · Answer 3

ram, faster drives and faster/more cpus all cost $$

an index is FREE

* Noel

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

FREE... but also much easier to implement, not to mention the right thing to do here .

delatush Valued Member Points: 56 More actions · Answer 5

Sorry got caught up with other things.

Take the other index's off and maket he 1 clustered Noel?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

No just created the clustered in on those 2 fields. No need to change anything else at the moment.

noeld SSC Guru Points: 96590 More actions · Answer 7

For the moment don't remove the others Just add the clustered!!

Like:

create unique clustered index IX_MY_UC on Yourtable(NumSet1,NumSet2) with fillfactor = 90

* Noel

delatush Valued Member Points: 56 More actions · Answer 8

Valued Member

Points: 56

August 5, 2005 at 2:15 pm

Running now......

noeld SSC Guru Points: 96590 More actions · Answer 9

SSC Guru

Points: 96590

August 5, 2005 at 2:16 pm

Man you are fast!!

* Noel

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

Yup... leaving fast here too (1 hour early). I just I'll be able to do that when I work for you .

Ok now I'm really gone.

delatush Valued Member Points: 56 More actions · Answer 11

Just stopped it on 10 minutes, no results, going to add the fill factor.

noeld SSC Guru Points: 96590 More actions · Answer 12

Have a good weekend!!

We'll see about that!

* Noel

noeld SSC Guru Points: 96590 More actions · Answer 13

How much memory do you have on the server ?

* Noel

delatush Valued Member Points: 56 More actions · Answer 14

Going to stop and start sql services and free up some resources,

I think there is a gig, am going to go check.

noeld SSC Guru Points: 96590 More actions · Answer 15

one more thing run UPDATE STATISTICS YourTableName WITH FULLSCAN

and Try again

if still slow can you post your execution plan ?

* Noel