THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

Here are some oldies, but goodies that I recommend you read:

Two Partitioning Peculiarities and Aggregates and Partitioning

Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White (b | t).

The Price of Not Purging

Holding on to data long after its useful lifespan contributes to bloat and added preventative maintenance headaches. Read this informative post from Erin Stellato (b | t), of SQLSkills.com, where you’ll find a lot of useful information about the direct role that database size plays in the duration of all sorts of transactions and administrative operations.

Why is my intermediate result set so huge?

Over at our SQL query tuning forum on Answers.SQLPerformance.com, you should read this entry to see a strong real-world example of why table-valued functions (that should set of warning klaxons!) can be a mixed blessing or, in some cases, even a curse.

Follow-up on Summer Performance Palooza

I like Q&A articles, often because someone smarter than me has thought of a question I should have thought of but didn’t. Aaron Bertrand (b | t), the editor-in-chief at SQLPerformance.com, recaps his performance presentation for the PASS VC Summer Performance Palooza including an expansive Q&A section covering all of the questions that came in during and after the presentation.

What's in your recommended reading list? Thanks,

 
-Kev

-Follow me on Twitter!

Published Monday, March 30, 2015 10:24 AM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

hzx said:

http://www.michaelkorsoutletblackfriday.us.com

http://www.michaelkorsoutletdiscount.us.com

http://www.canadagooseoutletsonline.us.com

http://www.michaelkorsoutletwholesale.us.com

http://www.nikeshoesuk.org.uk

http://www.canadagoosejacketsofficial.com.co

http://www.mbtshoesclearanceoutlet.us.com

http://www.uggs-outletstores.us.com

http://www.moncleroutletmoncler.us.com

http://www.canadagoose-outletonline.us.com

http://www.airmax2017.us.org

http://www.raybansunglassesseller.com.co

http://www.polo-ralphlauren-pascher.fr

http://www.adidassuperstars.us.com

http://www.katespade-outlets.in.net

http://www.michaelkorsoutlet-clearances.us.com

http://www.christianlouboutinoutletshoes.us.com

http://www.asics-runningshoes.us.com

http://www.pandoracharmsstore.us.com

http://www.coachfactoryoutletonlinestore.us.com

http://www.coachoutletonlinesofficial.us.com

http://www.ralphlaurenoutletstores.us.com

http://www.canadagoosejacketscanada.ca

http://www.coach-outletcanada.ca

http://www.coachoutletstoreofficials.us.com

http://www.ralphlaurenpolooutlets.me.uk

http://www.pandoracharmssaleclearances.us.com

http://www.pandoracharmsus.us.com

http://www.michael-korshandbags.in.net

http://www.pandoracharmsofficials.us.com

http://www.coach-outletonlineclearance.us.com

http://www.nfljerseyswholesalenike.us.com

http://www.pandoraoutletclearance.us.com

http://www.uggoutletstores.ca

http://www.michael-korsoutlets.org.uk

http://www.canadagooseoutlet-stores.name

http://www.christianlouboutinoutletonlines.us.com

http://www.uggoutletsuggs.us.com

http://www.outletsugg.us.com

http://www.canadagoosejacketsshop.us.com

http://www.pandoraoutlets.us.com

http://www.michaelkorsclearanceoutlet.us.com

http://www.nfljerseysnfl.us.com

http://www.mlbjerseys.net

http://www.pandoraoutletfactory.us.com

http://www.mlbjerseyscom.us.com

http://www.fredperryoutlet.us.com

http://www.fitflopsaleclearance.us.com

http://www.oakleysunglasses.co.uk

http://www.coachoutletonlineoutlet.us.com

http://www.true-religion.us.com

http://www.moncleroutletjackets.us.com

http://www.giuseppezanottioutlet.us.com

http://www.coachoutletsalefactory.us.com

http://www.pandorajewelryorg.us.com

http://www.coachoutletsonlinefactory.us.com

http://www.uggoutletonlineclearances.us.com

http://www.raybansunglassesdesigner.us.com

http://www.canadagoose.name

http://www.nikeshoesforwomen.us.com

http://www.uggsoutletsboots.us.com

http://www.coachfactoryoutlet-stores.us.org

http://www.pandorajewelryclearance.us.com

http://www.coachfactoryoutleta.us.com

http://www.pandoracharmsonlines.us.com

http://www.coachfactoryoutletstoreofficial.us.com

http://www.pandora-jewelryclearance.us.com

http://www.fitflops-saleclearance.us

http://www.canadagoosejacketsstores.org.uk

http://www.louboutinshoesuk.me.uk

http://www.michaelkorsoutletmkr.us.com

http://www.poloralphlaurenonlines.us.com

http://www.uggoutletssale.us.com

http://www.kate-spadeoutlets.us.com

http://www.ralphlauren-saleclearance.org.uk

http://www.raybansunglasseseyewear.us.com

http://www.edhardy.us.org

http://www.redbottomsshoes.us.org

http://www.truereligionjeanoutlet.us.com

http://www.coachoutletfactorysale.us.com

http://www.coachoutletfactorysite.us.com

http://www.nike-shoes.us.org

http://www.michaelkorsoutletkor.us.com

http://www.toryburchoutlet.us

http://www.supremeoutlets.us.com

http://www.ralphlaurenpolos.org.uk

http://www.adidasoutlet.us.org

http://www.nike-shoes.us.com

http://www.lunetterayban.fr

http://www.michaelkorsoutletmichael.us.com

http://www.polooutletstores.us.org

http://www.cheapnfljerseysnfl.us.com

http://www.coachoutletcoachfactoryoutlets.us.com

http://www.katespadeoutletonsale.us.com

http://www.cheapuggsboots.com.co

http://www.michaelkorsoutletks.us.com

http://www.coach-outletonline.us.org

http://www.ralphlaurenpolosale.us.com

http://www.oakley-sunglasses.org.uk

http://www.michaelkorsoutletstoresale.us.com

hzx20180712

July 11, 2018 11:56 PM
 

chenjinyan said:

http://www.cheapmichaelkorshandbags.us.org

http://www.toryburchoutletmall.us.com

http://www.yslmakeup.us

http://www.marcjacobsbags.us.com

http://www.pandoraukcharms.co.uk

http://www.adidasnmdforsale.us.com

http://www.fansoccerjerseys.com

http://www.miumiu.us.com

http://www.spaldingbasketball.us

http://www.ralphlaurenoutletofficial.us.com

http://www.ninewest.us.com

http://www.outletralph-lauren.us.com

http://www.jordans-fusion.com

http://www.onitsukatigershoes.us.com

http://www.nikeflipflops.org

http://www.nikeblazers.us

http://www.huarache.us.com

http://www.stuartweitzmanshoes.us.com

http://www.hermesbags.me.uk

http://www.jordan6.net

http://www.balenciagasandals.us.com

http://www.airjordan11.us

http://www.montblancpen.in.net

http://www.rayban-sunglassesonsale.us.com

http://www.nikeoutletstoreonline.us.com

http://www.underarmouroutletclearance.com

http://www.jerseys.eu

http://www.givenchyhandbags.us.com

http://www.birkenstockoutlet.us.org

http://www.louboutinchristian.us.com

http://www.adidasslides.us.com

http://www.coachoutlet-handbags.us.com

http://www.kobe11.in.net

http://www.mizunorunningshoes.org

http://www.airmax1.us

http://www.canadagoose-sale.ca

http://www.christianlouboutinshoessale.org.uk

http://www.christianlouboutinoff.us

http://www.basketballshoesstore.us.com

http://www.off-whiteclothing.us.com

http://www.nikepresto.us.com

http://www.cheapbestnbajerseys.us.com

http://www.pandorajewelrys.ca

http://www.christiandiorhandbags.us.com

http://www.truereligionjeans-outlet.us.com

http://www.lebron14.org

http://www.persolsunglasses.us.com

http://www.adidassuperstarshoes.us.com

http://www.hardenvol1.us.com

http://www.fitflops.us.org

http://www.cheapjerseys.in.net

http://www.converseshoes.name

http://www.cheapmlbjerseysshop.us.com

http://www.rayban.nom.co

http://www.coachoutlet-online.eu.com

http://www.jordanxx9.in.net

http://www.air-jordan.us.com

http://www.dansko.us.com

http://www.superdry.me.uk

http://www.x-largeclothing.com

http://www.jordan4.net

http://www.nikeukstores.me.uk

http://www.prada.us.org

http://www.lebron13.org

http://www.mishka.us.com

http://www.nikeflightbonafide.us

http://www.poloralphlaurens.us.com

http://www.vancleefarpelsjewelry.us.com

http://www.fitflopsoutlet.us.com

http://www.burberryoutlet-canada.ca

http://www.yoga-pants.us.com

http://www.jimmychoooutlet.us.com

http://rayban.sunglassesoutlet.us

http://www.michaelkorsoutlet70off.us.com

http://www.timberlandpro.us.com

http://www.lululemon.in.net

http://www.pradaoutletonlinestore.us.com

http://www.ralphlaurenpolo.in.net

http://www.supremeuk.co.uk

http://www.ralphlauren.in.net

http://www.parajumpersjackets.us.com

http://www.mcm-outlets.us.com

http://www.adidasstoreuk.me.uk

http://www.maillotdefootcenter.fr

http://www.magliacalcioshop.it

http://www.toryburchoff.us.com

http://www.louboutins.us.com

http://www.lindafarrowsunglasses.com

http://www.coachoutletonline-sale.us.com

http://www.philipp-pleinoutlet.com

http://www.nikedunksb.us

http://www.columbiaoutlet.us.org

http://www.vetementsclothing.com

http://www.nikecortez.net

http://www.rolexwatches.us.com

http://www.airmax2018.in.net

http://www.jordan12.org

http://www.baseballjersey.us.com

http://www.nikekd10.us.com

http://nike.outletstore.us.com

20188.23chenjinyan

August 22, 2018 11:18 PM
 

obat batuk kronis said:

https://goo.gl/KTrjVR Obat herbal kolesterol terbaik

https://goo.gl/9qCgf9 Obat Batuk Kronis Alami Terbaik

https://goo.gl/HQh67p Masker wajah alami untuk menghilangkan jerawat

https://goo.gl/4UJxUL Obat liver alami aman dan terbaik

https://goo.gl/j3PFHJ Obat herbal sinusitis kronis terbaik

https://goo.gl/W5W8F9 Obat bronkitis anak secara alami

https://goo.gl/2AsGLu Obat Kanker Payudara terbaru 2018

https://goo.gl/ssFQGs Cara meningkatkan nafsu makan secara alami

https://goo.gl/KSnnFb Obat herbal diabetes menurunkan gula darah

https://goo.gl/ngiymL Obat herbal kusta terbaik

https://goo.gl/ZsjaLf Obat benjolan di leher tanpa operasi

https://goo.gl/arrkfe Obat Herbal Kanker Otak tuntas hingga akar

https://goo.gl/VBFyi2 Obat TBC alami aman tanpa efek samping

https://goo.gl/ooXyhS Obat radang amandel sembuh tanpa operasi

https://goo.gl/94gZFX Obat asam urat alami tanpa efek sampinfg

https://goo.gl/Ld4VKF Obat tetes Sariawan secara alami

https://goo.gl/8v2oKL Cara mengobati mata bengkak dengan cepat

https://goo.gl/pnP3nA Obat tradisional kanker lambung terbaik

https://goo.gl/96UaW3 Obat kanker paru paru

https://goo.gl/bjzQzS Obat usus buntu alami tanpa operasi

https://goo.gl/PUDELN Obat asam lambung naik cara alami

August 27, 2018 8:23 PM

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Archives

Privacy Statement