Neil Belcher, Cornell University
Using SQL to generate SQL scripts can be a very powerful tool for doing many mundane data tasks. This technical session will walk through example SQL statements that can make your life much easier. For example: How about SQL that generates a list of CREATE INDEX statements for Dimension and Fact tables, a list of ALTER TABLE statements to create PK/FK’s or “Uber Minus” statements that compare the data between two tables? What is in your SQL toolbox? This session will include Oracle and Transact-SQL examples. Attendees are encouraged to bring their favorite SQL snippets to share as well.