The second day was just as informative as the first. I am bummed we are done but I needed to get back to work anyway.
Some interesting things from Day 2:
create | drop if [not] exists
Long time coming, IMO. Gives you the ability to write SQL like the following
create database if not exists db with log; create table if not exists tab1 ( field1 integer, field2 char(2) ); drop table if exists tab2;Index Extent Sizing
You can now specify the first and next extent sizes for your indexes instead of relying on the engine to guestimate what your index extent sizes should be based on index key size and table size.