Access articles and resources written by some of the best Oracle brains in the world.
Temporary Tables in Oracle and SQL Server
Presented by Jonathan Lewis (Oracle ACE Director, OakTable) and Grant Fritchey (SQL Server MVP)
Thurs 11th October 2012
This webinar has now finished, but feel free to click the button above to watch the recording.
If you missed the Q+A, or we were unable to answer your question, or you would like to ask the presenters a new question, please use the comments function under the post on: All Things Oracle.com.
Temporary tables are often used in applications for processes that are difficult to complete in a single pass. They are widely used in SQL Server development and can be local and global. In Oracle temporary tables are created with a static global definition, but are used to hold temporary local content. But is this the only difference in temporary tables in Oracle and SQL Server? What about the performance impacts/gains for using temporary tables, and does this differ in Oracle and SQL Server?
Once again Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.
Will they agree on some common ground? Or will it be an out and out argument? Either way, be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.
A Q+A session with Jonathan and Grant will follow the presentation.
Jonathan Lewis is a well-known figure in the Oracle world with more than 23 years' experience using the software. He is a founding member of the OakTable Network and Oracle ACE Director. Jonathan has published two books about Oracle, has contributed to three others, and has just completed a new book (Oracle Core: Apress) on the Oracle database engine. He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world.
Grant Fritchey is a SQL Server MVP, and highly respected SQL Server DBA and developer. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG) and it's current president.
- Compare 2 schemas and see highlighted differences side-by-side
- Automatically create update scripts to migrate any changes