In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS & AVG_RANGE_ROWS.
Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources)
Connect With The Speaker (Amit Bansal)
-Follow on Twitter: https://twitter.com/A_Bansal
-Follow on FaceBook at http://www.facebook.com/amit.r.bansal
-Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010
-Facebook Page: https://www.facebook.com/AmitRSBansal/
Connect with SQLMaestros: http://sqlmaestros.com/
-Email us: [email protected]
Have technical questions?
Join the largest SQL group on FB
Our LinkedIn group
DataPlatformGeeks (DPG) Community
Join the fastest growing community of data & analytics professionals
Why Join DPG? http://www.dataplatformgeeks.com/
-Attend all events hosted by DPG, including SQLMaestros Special Events
-Get access to free videos, labs, magazines and host of learning resources
-Download all events & conference material
-Learn new skills. Sharpen existing skills
-Be part of Asia’s Largest Data/Analytics Community
-Opportunity to be a regional mentor & speaker at our events
-Immense technical & professional development
Do you know about Data Platform Summit? http://www.DPS10.com
This is a unique real vampire website for vampires as well as the curious. It has valuable information for any real vampire and is based on scientific evidence. It also leads to other good websites for real vampires.
This is why I "think" Im a real vampire They have no desire to use us as lab rats or slaves. Before reading any farther on this site, This website is not made for poser vamps, close-minded people, or those who think that they are, or claim to be a vampire because they think the spirit of a vampire entered them at some time making them a vampire. We call these people posers, which they are; they are confused lost children. This site is not here for them in any way! It is for real vampires, curious people, and open-minded skeptics. The best compliment that you can give to this site, is telling all of your friends about it.
Real vampires are not pure fiction.
The Headache Paradox: It is scientifically impossible to have a headache, seeing that there are no pain receptors in the brain. Yet we continue to search for answers to what causes a headache, because we all know that headaches do exist.
Between a combination of the fact that our brains are roughly nothing more than a highly advanced mass of nerves, and that every function is controlled by signals that our brain sends through our nerves to the rest of our bodies, I think that if we could somehow make our nerves send stronger, more efficient signals at a quicker speed it would have a lot of different results. Including heightened sense (both physical and psychic) moving quicker both running and walking along with arm movement etc. The brain being just nerves would obviously also be effected, resulting in quicker more efficient thinking, which naturally would make us smarter, more observant, and have much sharper reflexes.
Some say that is an overly simplified form of how the brain functions, which it is. To them I say make the axons 12-15% wider, resulting in signals being sent much more quickly through the brain. Allowing neurons to create more connections without loss of speed, and the 10,000+ miles of blood vessels in the brain doubling as an additional cooling system for the brain. I could write a book on the cascade of effects that alone causes for people when they are changed in to a real vampire, however for now I will leave it in this simplified form.