Premier Sponsors
 
http://www.anderson.ucla.edu 
 
http://www.sqlpass.org 
 
http://oreilly.com/ 
 
http://pyramidanalytics.com/ 
 
http://www.sqlpower.com/ 
 
http://www.idera.com/ 
 
http://www.telerik.com/ 
 
http://pluralsight.com/training 
 
Now Celebrating Our User Group's 10th Anniversary!
We invite you to participate in the following SQL Server event:

24 Hours of PASS on September 9, 2014

http://www.sqlpass.org/24hours/2014/summitpreview/About.aspx
Los Angeles SQL Server Professionals Group Presents ...
Thursday, September 18, 2014
Query Processing in In-Memory OLTP
Speaker: Benjamin Nevarez

Query Processing in In-Memory OLTP

In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

  

Bio

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals”. With more than 20 years of experience in relational databases, Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits. Benjamin’s blog can be found at http://www.benjaminnevarez.com and he can also be reached by e-mail at admin at benjaminnevarez dot com and on twitter at @BenjaminNevarez.

 

6:30 PM, Registration and Refreshments
7:00 PM to 9:30 PM, Presentations
UCLA Anderson School of Management
Cornell Hall, Room D307



Please follow this link for directions.
This meeting is generously sponsored by: O'Reilly

www.oreilly.com
Parking: Please park in Parking Structure 4.
Cost: $5.00 Admission. Parking in PS-4 costs $12.00.