Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
Unavailable
Please enter a password with at least 8 characters.
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
Please double check your email address. Your emails do not match.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Postal code may contain no more than 9 letter or number characters.
Please double check your website URL.
All fields marked with * are required.
Your card expiration date is in the past.
Your card CSC needs to be 4 digits.
Please confirm your order: $$$$ You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your card CSC needs to be 3 digits.
Sofort is only available in Germany and Austria.
Boleto Bancario is only available in Brazil.
PagoFacil is only available in Argentina.
Rapipago is only available in Argentina.
Please enter a valid IBAN number.
You need to accept to charge your bank account.
Your billing zip code needs to be 5 digits.
Please double check your CEP info. The CEP format should be something like 12345-678.
Please double check your tax identifier.
There was a problem saving your address.
There was a problem saving your card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
card number is in invalid format.
Wrong card type or card number is invalid.
card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Job titles must be less than 50 characters.
Please enter a donation amount.
Please select an attendee for donation.
There is currently an issue with card submission on Safari with iOS7. Please try again with a different browser or device.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
SQL Saturday #497 - Full Day Preconference Session
SQL Server Index Formulas: Problems and Solutions with Kendra Little
Abstract
Every SQL Server developer needs to know the essentials of clustered and nonclustered index design. You need to determine when indexed views, filtered indexes, and partitioning are the right fit for an application, and when a new index will improve performance on a live SQL Server workload. In this example-packed day long session, Microsoft Certified Master Kendra Little will use a series of problems and solutions to teach you how to create and tune indexes to improve query performance and make your applications faster. You'll leave the course with a set of online exercises to keep building your index skills.
Hear from Kendra what you will learn in this course - Intro Video
Detailed Agenda for Pre-Con
You're a SQL Server Developer, and you're ready to learn how to code the best indexes. In this day long, example-packed seminar, you will build your index design and tuning skills with Microsoft Certified Master Kendra Little. You will learn:
Why choosing the right key column order can make a huge difference in query performance
How included columns can be used in more ways than you might expect
Good and bad formulas for clustered indexes and guidelines to keep your table schema efficient
When indexed views will make your queries faster and how to avoid pitfalls with them in both Standard and Enterprise Edition
How to find and interpret index requests from SQL Server's "missing index" feature
How to identify which queries need indexes the most using the execution plan cache and SQL Server 2016 Query Store
How to identify the paradigms where table partitioning shines
What partition elimination is, why it's critical to query performance, and how to tell if it's happening in your queries
Scenarios where Partitioned Views are the best fit
You'll get scripts for all the examples in this demo packed course, plus a set of online exercises to further increase your knowledge after the day is over.
Kendra Little
Kendra Little is a teacher, author, and Microsoft Certified Master in SQL Server. She loves helping people write fast code, troubleshoot problems, and design reliable database systems.
FAQs
What is the refund policy?
Once purchased, tickets are non-refundable. Tickets are transferrable.
What does the ticket include?
The ticket for the event includes the following:
Access to Session Material for the Pre-Conference Workshop
Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at sqlsaturday497@sqlsaturday.com
What should I bring to the event?
There will be a lot of information presented at the event so you will likely need something to take notes. If you have a laptop with SQL Server installed you may be able to follow along with demos or try techniques on your own databases
Where on campus is the event located?
Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.
Does this register me for the SQL Saturday event the next day?
No. If you are plannig on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/497/register.aspx.
What if I have Questions?
Please email us at sqlsaturday497@sqlsaturday.com.
Have questions about SQL Server Index Formulas: Problems and Solutions with Kendra Little?
Contact SoCal SQL Saturday
Share SQL Server Index Formulas: Problems and Solutions with Kendra Little
Share Tweet