V8/V9 SQL/Database Challenges and Solutions

Date: 
Thursday, 26 June, 2008 (All day)
Speaker: 
Susan Lawson

Objectives:
Discuss the importance of smart SQL and applications
Discuss V8 SQL and application features and show examples
Discuss V8 features for database performance
Discuss challenges still remaining in V8 SQL/applications and databases
Look at some new V9 SQL/application and database features and their benefits

Outline:
V8 SQL/Application Performance Features
Multi-Row Fetch
Recursion
Common Table Expressions
INSERT within a SELECT
Scalar Fullselect
Distribution Statistics
XML Scalar Functions
Multiple Distinct
Matching Predicates
Parallelism and Sorting
V8 Database Performance Features
Volatile Tables
Data Partitioned Secondary Indexes
V9 SQL/Application Features
UPDATE/DELETE with a SELECT
Optimistic Locking
Index on Expression
Histogram Statistics
Order By and Fetch First in Subselect
Instead of Triggers
INTERSECT and EXCEPT
Skip Locked Data
Caseless Expressions
Native SQL Procedures
XML Support
Star Joins Performance
New Functions
V9 Database Performance Features
Better Index Page Splitting
Index Compression and Large Pages
DPSI Enhancements
Clone Tables
Append on Insert
Truncate Table
No Log Tables

Full Abstract:
In this seminar we will look at some of the performance features in V8 and how they have been successfully used in our applications and databases to meet some of our current performance challenges. Those challenges, of course, being performance and availability. We will discuss some of the things we still desire in terms of application and database performance and take a look at V9 to see what features are available to further improve our performance and availability of our applications. We will look at how we may take advantage of those features.
 

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020