Fort Worth SQL Server Users Group

 

Posts From August, 2017

-April 2024+
SMTWTFS
31123456
78910111213
14151617181920
21222324252627
2829301234
567891011
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

So how does SQL Server take a query and decide what to do with it? 

Presented by Forrest McDaniel
Posted by altadmin Thursday, August 3, 2017 7:43:00 PM
AUGUST 16th - Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract: There are many internal mechanisms that SQL Server uses to build a query plan. Join me as I survey the process, with special attention paid to cardinality, statistics, and the memo. DBCC commands and undocumented trace flags abound as I show how to investigate internals for yourself. Only some of the presentation will be useful, but all of it will be nerdy!

Bio: Forrest McDaniel
I've only been a DBA for two years, so don't take my word for anything!
Before this new career I was a teacher and tutor, so I love explaining concepts, especially math.
http://fwssug.com/Blog/ViewArchive.aspx?month=8&year=2017&pageid=2&mid=2