Training: SQL Advanced Indexing and Tuning Feb 4-5

SQL Performance and Tuning bbarker at itcodingcamp.com
Thu Jan 31 07:04:44 GMT 2019


Learn SQL Advanced Indexing From the Experts
2-Day Training Class
 

SQL Advanced Indexing and TuningFeb 4-5
Special Pricing $425



Reading the Execution Plan
Learn to read this complex wealth of information and how to leverage the power of the SQL optimizer.
Keep and retrieve execution plans and dynamically choose the best ones for given data scenarios.

Designing Covering Indexes
Apply an indexing strategy to those "Problem" Queries and free up the system from long-running queries and reports.
Learn how to monitor IO and CPU utilization over time to improve the query performance.

Clustered Index Optimization 
Optimize the physical storage of data to match the usage and query pattern of your needs.  
Learn how to break-up the ?junk-drawer? of files and free SQL to quickly find and resolve queries, improving search speeds drastically.

Partitioning Hot Spots
Learn how to partition data based on dates or other filters, limiting the physical IO necessary to resolve long running and complex queries.
Create a rolling partitioning scheme to constantly keep the needed data easily accessible.

ColumnStore Indexes
Learn how to use Column Storage of data to speed retrieval based on the cardinality of your data.
This technology is used in Oracle and DB2 and is now available in SQL server. 

In-Memory Optimization & Native Procedures
Learn how to utilize in-memory tables and SSD technologies to speed insertion and updating of data.
Create native compiled stored procedures to boost data insert times by 400%.



Click Here For More Info

Unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-zope-developers/attachments/20190131/194b147b/attachment.html>


More information about the pkg-zope-developers mailing list