{"id":656,"date":"2010-10-12T11:34:00","date_gmt":"2010-10-12T11:34:00","guid":{"rendered":"\/blogs\/paul\/post\/T-SQL-Tuesday-11-Misconceptions-about-EVERYTHING!!.aspx"},"modified":"2021-10-12T15:19:49","modified_gmt":"2021-10-12T22:19:49","slug":"t-sql-tuesday-11-misconceptions-about-everything","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/","title":{"rendered":"T-SQL Tuesday #11: Misconceptions about&#8230;. EVERYTHING!!"},"content":{"rendered":"<p><span style=\"font-family: verdana,geneva; font-size: small;\"><img decoding=\"async\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg\" alt=\"\" width=\"150\" height=\"150\" border=\"0\" \/> <\/span><\/p>\n<p><span style=\"font-family: verdana,geneva; font-size: small;\">This month&#8217;s T-SQL Tuesday is being run by fellow-MVP Sankar Reddy (<\/span><span style=\"font-family: verdana,geneva; font-size: small;\">blog<\/span><span style=\"font-family: verdana,geneva; font-size: small;\">|<\/span><a href=\"https:\/\/twitter.com\/SankarReddy13\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">twitter<\/span><\/a><span style=\"font-family: verdana,geneva; font-size: small;\">) and the topic is about\u00a0<\/span><span style=\"font-family: verdana,geneva; font-size: small;\">Misconceptions in SQL Server<\/span><span style=\"font-family: verdana,geneva; font-size: small;\">. <\/span><\/p>\n<p><span style=\"font-size: small;\">(Check out the 60-page PDF with all the myths and misconceptions blog posts collected together: <a href=\"https:\/\/www.sqlskills.com\/insidercontent\/commonsqlservermyths.pdf\" target=\"_blank\" rel=\"noopener\"><span style=\"font-family: verdana,geneva; font-size: small;\">CommonSQLServerMyths.pdf<\/span><\/a>)<\/span><\/p>\n<p><span style=\"font-family: verdana,geneva; font-size: small;\">Back in April I spent an entire month doing a DBA-Myth-A-Day series once a day which was all about misconceptions. So, rather than repeating some of what I said then, or spilling the beans on some more myths I&#8217;ll be discussing at <\/span><a href=\"https:\/\/www.sqlskills.com\/upcomingconferences.asp\"><span style=\"font-family: verdana,geneva; font-size: small;\">PASS and SQL Connections<\/span><\/a><span style=\"font-family: verdana,geneva; font-size: small;\"> in November, this post will be an uber-list of all the misconceptions I debunked during April &#8211; and, boy, there are a lot of them! I keep hearing these myths over and over, from all kinds of people, including SQL MVPs, vendors, and consultants.<\/span><\/p>\n<p><span style=\"font-family: verdana,geneva; font-size: small;\">These posts explain in detail why the misconception is a misconception and in many cases use a script to prove it as well.<\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-3030-backup-myths\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (30\/30) backup myths<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post debunks my top 30(!) myths around backups.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2930-fixing-heap-fragmentation\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (29\/30) fixing heap fragmentation<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains why dropping and recreating a clustered index is not a good solution for removing heap fragmentation.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2830-bulk_logged-recovery-model\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (28\/30) BULK_LOGGED recovery model<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post debunks myths around bulk logging for DML operations, how BULK_LOGGED can affect your DR plan, and whether BULK_LOGGED affects log backup size.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2730-use-backup-with-checksum-to-replace-dbcc-checkdb\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (27\/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains why you can&#8217;t avoid running proper consistency checks.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2630-nested-transactions-are-real\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (26\/30) nested transactions are real<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains how nested transactions are really a SQL Server dev team joke on all of us.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2530-fill-factor\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (25\/30) fill factor<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains when fill factor is adhered to, the difference between 0 and 100, and why it only affects the leaf-level of an index.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2430-twenty-six-restore-myths\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (24\/30) twenty six restore myths<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post debunks my top 26(!) myths around restores.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2330-lock-escalation\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (23\/30) lock escalation<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains how lock escalation does NOT go row-to-page and then page-to-table, ever.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2230-resource-governor-allows-io-governing\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (22\/30) resource governor allows IO governing<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">Just as it says &#8211; hopefully this will appear in SQL11.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2130-corruption-can-be-fixed-by-restarting-sql-server\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (21\/30) corruption can be fixed by restarting SQL Server<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains why the vast majority of the time this isn&#8217;t true.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-2030-restarting-a-log-backup-chain-requires-a-full-database-backup\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (20\/30) restarting a log backup chain requires a full database backup<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains that a differential backup will work just fine.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1930-truncate-table-is-non-logged\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (19\/30) TRUNCATE TABLE is non-logged<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains how and why a TRUNCATE *is* logged and proves it by showing the log records generated.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1830-filestream-storage-garbage-collection-and-more\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (18\/30) FILESTREAM storage, garbage collection, and more<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post addresses five common myths about FILESTREAM storage and internals.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1730-page-checksums\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (17\/30) page checksums<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post addresses siz common myths around page checksums.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1630-corruptions-and-repairs\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (16\/30) corruptions and repairs<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">Most of what you&#8217;ve ever heard are misconceptions I&#8217;m afraid.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1530-checkpoint-only-writes-pages-from-committed-transactions\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (15\/30) checkpoint only writes pages from committed transactions<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains how checkpoint works.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1430-clearing-the-log-zeroes-out-log-records\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (14\/30) clearing the log zeroes out log records<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains how log clearing really works.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-dba-myth-a-day-1330-you-cannot-run-dmvs-when-in-the-80-compat-mode-t-sql-tuesday-005\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A DBA myth a day: (13\/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains how to call DMVs using 2005 syntax in 80-compat mode databases.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (12\/30) tempdb should always have one data file per processor core<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">One of the most confusing misconceptions out there.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1130-database-mirroring-failover-is-instantaneous\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (11\/30) database mirroring failover is instantaneous<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">Marketing nonsense, and I explain why.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-1030-database-mirroring-detects-failures-immediately\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (10\/30) database mirroring detects failures immediately<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">More marketing nonsense.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-930-data-file-shrink-does-not-affect-performance\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (9\/30) data file shrink does not affect performance<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">I&#8217;m still laughing about this one&#8230;<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-830-unicorns-rainbows-and-online-index-operations\/\">A SQL Server DBA myth a day: (8\/30) unicorns, rainbows, and online index operations<\/a><\/span>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">Why &#8216;online&#8217; is a bit of a misnomer&#8230;<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-730-multiple-mirrors-and-log-shipping-load-delays\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (7\/30) multiple mirrors and log shipping load delays<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This post explains why you can&#8217;t have multiple mirrors.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-630-three-null-bitmap-myths\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (6\/30) three null bitmap myths<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">Just as it says&#8230;<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-530-awe-must-be-enabled-on-64-bit-servers\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (5\/30) AWE must be enabled on 64-bit servers<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">It&#8217;s no wonder this is confusing&#8230;<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-430-ddl-triggers-are-instead-of-triggers\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (4\/30) DDL triggers are INSTEAD OF triggers<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">If only&#8230;<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-330-instant-file-initialization-can-be-controlled-from-within-sql-server\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (3\/30) instant file initialization can be controlled from within SQL Server<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">This is tricky as it&#8217;s partly true.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-230-dbcc-checkdb-causes-blocking\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (2\/30) DBCC CHECKDB causes blocking<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">I take that misconception as a personal afront :-)<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/a-sql-server-dba-myth-a-day-130-in-flight-transactions-continue-after-a-failover\/\"><span style=\"font-family: verdana,geneva; font-size: small;\">A SQL Server DBA myth a day: (1\/30) in-flight transactions continue after a failover<\/span><\/a>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\">Common failure when designing and HA strategy.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: verdana,geneva; font-size: small;\">And there you have it &#8211; over 100 myths and misconceptions debunked, explained and, in many cases, proven!<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This month&#8217;s T-SQL Tuesday is being run by fellow-MVP Sankar Reddy (blog|twitter) and the topic is about\u00a0Misconceptions in SQL Server. (Check out the 60-page PDF with all the myths and misconceptions blog posts collected together: CommonSQLServerMyths.pdf) Back in April I spent an entire month doing a DBA-Myth-A-Day series once a day which was all about [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61,99],"tags":[],"class_list":["post-656","post","type-post","status-publish","format-standard","hentry","category-misconceptions","category-t-sql-tuesday"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!! - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!! - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"This month&#8217;s T-SQL Tuesday is being run by fellow-MVP Sankar Reddy (blog|twitter) and the topic is about\u00a0Misconceptions in SQL Server. (Check out the 60-page PDF with all the myths and misconceptions blog posts collected together: CommonSQLServerMyths.pdf) Back in April I spent an entire month doing a DBA-Myth-A-Day series once a day which was all about [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2010-10-12T11:34:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-12T22:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/\",\"name\":\"T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!! - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg\",\"datePublished\":\"2010-10-12T11:34:00+00:00\",\"dateModified\":\"2021-10-12T22:19:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T-SQL Tuesday #11: Misconceptions about&#8230;. EVERYTHING!!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!! - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/","og_locale":"en_US","og_type":"article","og_title":"T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!! - Paul S. Randal","og_description":"This month&#8217;s T-SQL Tuesday is being run by fellow-MVP Sankar Reddy (blog|twitter) and the topic is about\u00a0Misconceptions in SQL Server. (Check out the 60-page PDF with all the myths and misconceptions blog posts collected together: CommonSQLServerMyths.pdf) Back in April I spent an entire month doing a DBA-Myth-A-Day series once a day which was all about [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/","og_site_name":"Paul S. Randal","article_published_time":"2010-10-12T11:34:00+00:00","article_modified_time":"2021-10-12T22:19:49+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg","type":"","width":"","height":""}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/","name":"T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!! - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg","datePublished":"2010-10-12T11:34:00+00:00","dateModified":"2021-10-12T22:19:49+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2010\/7\/tsql2sday150x150.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/t-sql-tuesday-11-misconceptions-about-everything\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"T-SQL Tuesday #11: Misconceptions about&#8230;. EVERYTHING!!"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=656"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/656\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}