Request

Question

Request

Sean Pearce

SSCoach

Points: 15999
More actions
December 13, 2012 at 5:17 am

#393793

I hope I am not being too cheeky posting this here, but I would appreciate some page views on my article.
The article is about page deallocations on heaps in SQL Server.
http://eohmicrosoft.blogspot.com/2012/12/heaps-of-trouble.html
If I have overstepped then I will gladly remove the link.
Thanks
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 1

Nice article, I dont see the problem, as others have posted links to blogs etc.

In regards to the actual blog, it rings a few bells with something I'm seeing in project im currently 'tuning', there are at times a number of large deletes being run and im not sure they use the TABLOCK hint.

time to check to see if this could be causing this project an issue.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 2

Sean Pearce (12/13/2012)
I hope I am not being too cheeky posting this here, but I would appreciate some page views on my article.
The article is about page deallocations on heaps in SQL Server.
http://eohmicrosoft.blogspot.com/2012/12/heaps-of-trouble.html
If I have overstepped then I will gladly remove the link.
Thanks

Good article, Sean. Also shows some great logical steps for troubleshooting such things. Well done.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

Great Post!

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

Thanks for the kind words, a real compliment from professionals in my industry.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Loundy SSCertifiable Points: 6080 More actions · Answer 5

Nice article 🙂

[font="Times New Roman"]There's no kill switch on awesome![/font]

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

Nice article. Will keep that one bookmarked to help explain the size issues encountered with heaps.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

schleep SSChampion Points: 12585 More actions · Answer 7

Good read, learned something new, and it seems to confirm the adage "a clustered index for every table".