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!

35 comments:

Unknown said...

Thanks for giving me the useful information. I think I need it!
Happy Wheels , FNAF World , Five Nights At Freddy's

Unknown said...

Would be awesome to know where I are able obtain it. Please maintain up the very good job. We all require far more such website owners like you on the net and much fewer spammers. Fantastic mate! Jean Claude Van Damme | Jean Claude Van Damme | Jean Claude Van Damme | Racing Games

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.

Drag Racer V3 said...

Great! I like your post so much dragracerv3game.com

alicetaylor said...

This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something like this

lennyfacetext.com

Anonymous said...

I was very impressed by this post, this site has always been pleasant news. Thank you very much for such an interesting post. Keep working, great job! In my free time, I like play game: vex3game.com. What about you?

Unknown said...

I would like to thank you for the efforts you have made in writing this article.
sushi-cat2.com

Unknown said...

It seems I'm on the right track, I hope I can do well. The result was something I did and was doing to implement it.
www.clickjogosclick.com

ngocanhng said...

I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
Very interesting blog.
www.baixarfacebookgratis.com.br

harry said...

viu for pc

GG. said...

This publication is interesting.
call girl wirral

jonet said...

agen idn poker
poker idn bonus
cara daftar idn poker
poker idn terbaru
idn poker versi terbaru

jonet said...

game tembak ikan pc
game tembak ikan online
jual tembak ikan
tembak ikan game
download game tembak ikan online

jonet said...

situs sbobet
sbobet asia
alternatif sbobet
sbobet mobile indonesia
sbobet mobile com

jonet said...

sbobet wap
sbobet login
agen sbobet terpercaya
situs sbobet
sbobet asia

jonet said...

scr888 com
scr888 online
scr888 hack
kiosk scr888 login
scr888 free play

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

JannethManalu said...

Very interesting blog. Alot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definately interested in this one. Just thought that I would post and let you know

Agen Bola Sbobet

Tania Febriana said...

Permainan tembak ikan adalah permainan yang paling rame orang mainkan, apalagi jika pelayanannya yang sangat memuaskan bagi anda tentunya kalian pasti akan merasa sangat puas juga kan ?, bagi kalian yang sangat menyukai permainan tembak ikan bisa datang ke situs kami :)

layanan livechat joker123

livechat joker123


joker123 deposit 25rb

joker123 deposit pulsa

deposit slot joker123 ovo

livechat joker123


login joker388 slot apk

daftar akun joker388

download aplikasi joker388 apk

aplikasi joker388 apk


deposit joker388 pulsa

deposit slot pulsa

deposit slot aplikasi ovo

daftar joker388


login joker388


joker123 deposit via pulsa

deposit joker123 pulsa

live casino joker123

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

eva indra said...

Artikel ini sangat menarik untuk di baca.
Namun saya juga memiliki artikel yang menarik untuk kalian baca silahkan klik link dibawah ini untuk masuk ke artikel kami:

Download Aplikasi IDN Poker Apk Versi Terbaru Server IDNPlay Android dan iOS

Agen IDN Poker Apk versi Terbaru

IDNPLAY DEPOSIT PULSA

Gladis Vye said...

The presentation of the article is very good, every word written has a meaning and is very useful for the readers. I hope that you can write useful articles for readers like this, we also have several articles that are also interesting to read.
bandar judi bola
judi online bola

shorya 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

archi said...

Buy the best microwave convection oven for baking, cooking with buyers guide and review. best convection microwave oven in india

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

Cindy Wilia said...

Artikel yang sangat bagus dan hebat, saya tidak akan bosan membacanya jika tulisan anda bisa kalian pertahankan seperti ini. Namun kalian jangan lupa untuk membaca artikel kami lainnya di situs:
idnandroid.com
pokeronline-android.com

IDN Poker Mobile said...

Thanks for sharing this wonderful piece of information.
Stay up the good work!
I will notify

download idn poker
aplikasi idn poker

idn poker mobile