Wednesday, January 1, 2014

How to fix the fragmentation on heaps?


We know that heaps are the tables without clustered index on. It may have many non clustered index  (NCI) but still it is considered a heap. So consider a huge table (heap) that is fragmented. How would  you fix it? Technically, you cannot defrag a heap table.  But remember we have ALTER table REBUILD command which works very well on the heaps. But there is one big But. If you have many NCI on the table this command will rebuild all of them at once. What does it mean? It can produce transaction-log bloat which hits the over all performance. Think about the process the scan the log or perhaps Log Shipping job that needs to move the log file to the remote server. All this affects performance.

So, to answer the question ,we need to create a clustered index on that table..That is simple answer to the question.

Happy New Year to all!

14 comments:

huong duong said...

After all, life is also because you are self-employed, success or failure, forward or also stalled by you only.
download musicas , snapchat baixar , run 3 , b612 , geometry dash apk

Unknown said...

create the clustered index,, then drop it, maybe ? heap is happy ? Thank you.

GG. said...

This publication is interesting.
call girl wirral

Alodia said...

IDN Poker Versi 1.1.14.0 I am very happy to read the article that you created because in my opinion in the discussion of your article there is some important information and can be used as additional knowledge

Sophie Grace said...

Great! Thanks for sharing the information. That is very helpful for increasing my knowledge in this 192.168.l.254

smokegood said...

handicap sbobet 168
sbobet777
agen judi bola terbaik
situs ibcbet 168
judi bola sbobet pakai pulsa

Unknown said...

Come To Visit my site :)

colok bebas 2d

mistik lama mistik baru

cara bermain colok bebas

peraturan billiar

mistik lama dan baru

cara menang togel colok bebas

tabel taysen

Unknown said...

Checkout the best fitness band under 5000 to get your fitness track on routine. Choose from wide range of variety . best fitness band under 5000

Seira said...

IDNpoker menggunakan teknologi terbaru dalam menyediakan pengalaman game online yang luar biasa. Dengan jumlah pemain yang melebihi 600.000 setiap bulan serta 100 juta pengguna aktif yang tersebar di berbagai mitra IDNplay, kami merupakan server situs poker online terbesar di Asia. Selain poker, terdapat juga permainan lain yang mendukung semua mata uang asing untuk kenyamanan anda dalam bertransaksi. Terdapat 7 jenis permainan kartu online yang dapat anda nikmati seperti poker, ceme-keliling, domino, ceme, capsa, super-10 dan omaha.
naga77
daftar sbobet99
piala eropa
sbobet99
idn poker indonesia

Mihir Mane said...

Hire freelance models for modelling photoshoot and apply for freelance modelling jobs in India, freelance singing jobs, freelance bloggers jobs and others. jobs for singers

abhikhurana said...

Buy thoughtful gifts for your parents, grandma, grandpa, dad for Christmas. Make your
celebrations unique with these bestest gifts all around. gifts for brother

sanjupawar said...

Know what are the trending topics going on in india. Get some viral news about web series , bollywood and all soughts if Indian stuff. trending news in hindi

georgefernandis said...

Grab your hand on the best motivational, inspirational, thought in hindi, attitude, love, good morning, life, funny, sad, friendship quotes & status. motivational stories in hindi

SBOBET88 CASINO said...

I really like reading the articles that you make, so I want to read them continuously. Feel free to visit my web : link sbobet online