{"id":896,"date":"2005-12-07T12:00:00","date_gmt":"2005-12-07T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=896"},"modified":"2005-12-07T12:00:00","modified_gmt":"2005-12-07T12:00:00","slug":"sql-server-kicks-oracles-butt","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/12\/07\/sql-server-kicks-oracles-butt\/","title":{"rendered":"SQL Server Kicks Oracle&#8217;s Butt"},"content":{"rendered":"<p>What&#8217;s more, there&#8217;s <a href=\"http:\/\/www.samspublishing.com\/articles\/article.asp?p=375922&amp;rl=1\">a solid logical argument<\/a>. So that&#8217;s that, then!<\/p>\n<p><sigh> <\/sigh><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s more, there&#8217;s a solid logical argument. So that&#8217;s that, then!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-896","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":893,"url":"http:\/\/orcldoug.com\/blog\/2005\/12\/19\/another-10046-success\/","url_meta":{"origin":896,"position":0},"title":"Another 10046 Success","date":"December 19, 2005","format":false,"excerpt":"We're implementing a new packaged application at work. It includes a history import job that takes data in a flat-file and loads it into database tables. It performs some degree of data transformation but, in essence it inserts about 500,000 rows into one table and thousands in to a few\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":930,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/21\/ukoug-agenda\/","url_meta":{"origin":896,"position":1},"title":"UKOUG Agenda","date":"October 21, 2005","format":false,"excerpt":"What's good enough for Niall is good enough for me ... Here's my agenda for the UKOUG conferenceSunday - Oak Table day. Like Niall, I won't be there at the start, but even half a day of this standard will add a lot to the conference for me. Then onto\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1490,"url":"http:\/\/orcldoug.com\/blog\/2009\/04\/22\/how-to-generate-more-logical-reads\/","url_meta":{"origin":896,"position":2},"title":"How to generate more Logical Reads","date":"April 22, 2009","format":false,"excerpt":"(With my tongue starting to feel a little tired ...)Mmmm, there\u2019s a table that the application is accessing extremely frequently, called R_DUMMY. I wonder what data it contains? SQL> SELECT dummy_key FROM r_dummy; DUMMY ----- DUMMYMmmm, that looks familiar, doesn\u2019t it? It\u2019s almost like the DUAL table, isn\u2019t it? \u00a0\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1339,"url":"http:\/\/orcldoug.com\/blog\/2007\/11\/06\/the-reality-gap-3-a-single-instance-per-server\/","url_meta":{"origin":896,"position":3},"title":"The Reality Gap (3) &#8211; A Single Instance per Server","date":"November 6, 2007","format":false,"excerpt":"There will probably be about four or five of these posts in total. This is one I didn't mention in the original presentation because I didn't feel I could do it justice and because there was someone I wanted to have the right to reply. Step forward Tom Kyte.By coincidence,\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1429,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/20\/time-matters-db-time\/","url_meta":{"origin":896,"position":4},"title":"Time Matters &#8211; DB Time","date":"August 20, 2008","format":false,"excerpt":"[In retrospect, the title of that first blog post might have suited the subject, but doesn't translate too well for subsequent related blog posts. That was a lack of planning or foresight on my part. These blog posts are tumbling out of my head in a fairly incoherent way. Maybe\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1056,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/19\/ausougoaug-2006-conference-announcement\/","url_meta":{"origin":896,"position":5},"title":"AUSOUG\/OAUG 2006 Conference Announcement","date":"August 19, 2006","format":false,"excerpt":"The AUSOUG and OAUG committees are very excited to announce the Australian 2006 conference series is less than three months away. While our American neighbours are focusing on Oracle OpenWorld in October, and our UKOUG friends on their (extended!) November conference, Australians will not miss out with the largest Oracle\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=896"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/896\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=896"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}