{"id":73279,"date":"2012-10-15T13:22:50","date_gmt":"2012-10-15T13:22:50","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/temporary-tables-in-oracle-and-sql-server\/"},"modified":"2021-07-14T13:07:49","modified_gmt":"2021-07-14T13:07:49","slug":"temporary-tables-in-oracle-and-sql-server","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/temporary-tables-in-oracle-and-sql-server\/","title":{"rendered":"Temporary Tables in Oracle and SQL Server"},"content":{"rendered":"<p>This video is a follow up to the <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-temporary-tables-oracle-sql-server-jonathan-lewis?utm_source=allthingsoracle&#038;utm_medium=publink&#038;utm_content=webinar&#038;utm_campaign=deploymentsuitefororacle\" target=\"blank\">webinar<\/a> broadcast by <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/?utm_source=allthingsoracle&#038;utm_medium=publink&#038;utm_content=webinar&#038;utm_campaign=deploymentsuitefororacle\">Red Gate<\/a> on 13th September 2012. Please leave a response and ask questions at the bottom of the page.<\/p>\n<p><a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-temporary-tables-oracle-sql-server-jonathan-lewis\" target=\"blank\"><button class=\"btn\"><span>Watch video<\/span><\/button><\/a><\/p>\n<h2>Summary<\/h2>\n<p>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?<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>A Q+A session with Jonathan and Grant follows the discussion.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This video is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please leave a response and ask questions at the bottom of the page. Watch video Summary 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&hellip;<\/p>\n","protected":false},"author":101205,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73279","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/101205"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73279"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73279\/revisions"}],"predecessor-version":[{"id":91743,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73279\/revisions\/91743"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73279"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}