Performance enhancement of SQL Queries using Indexes

With our final settlement on SQL Query Tuning Performance. In this meetup we will see.

1. How to enhance Index and Indexed views on queries

2. Establish Common Table Expressions (CTEs).

3. Using Partitions and full text search.

This is a DIY (Do it yourself) session so please bring your laptop with you and install MS SQL server 2014/2016 with SSMS (SQL server Management Studio) before the event. Also, to install MSdata tools please follow this link below

https://figshare.com/s/e5844dd90be7adc3a720

Please, follow these links to Install SQL server 2014/2016 as well as SQL Server Management Studio 2014/2016 as below:

https://figshare.com/s/e5844dd90be7adc3a720

In case you have a problem finding us or you will be late, please call us on 9163 4228