{"version":"1.0","provider_name":"Database Tutorials","provider_url":"https:\/\/dbtut.com","author_name":"Rey Wang","author_url":"https:\/\/dbtut.com\/index.php\/author\/reywang\/","title":"EMC flash drive as Temp database device - Database Tutorials","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"YsohAdQ3Nc\"><a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\">EMC flash drive as Temp database device<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/embed\/#?secret=YsohAdQ3Nc\" width=\"600\" height=\"338\" title=\"&#8220;EMC flash drive as Temp database device&#8221; &#8212; Database Tutorials\" data-secret=\"YsohAdQ3Nc\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/dbtut.com\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"&nbsp; Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is way over 25TB, and we run very bizarre over 20 table joins, outer join\/self join. Mainly for financial risk reporting; the reporting tools are SAP &hellip;"}