{"id":1096,"date":"2011-03-17T13:37:19","date_gmt":"2011-03-17T05:37:19","guid":{"rendered":"http:\/\/www.alfredivy.per.sg\/blogger\/?p=1096"},"modified":"2015-12-01T13:54:01","modified_gmt":"2015-12-01T05:54:01","slug":"how-wide-is-it","status":"publish","type":"post","link":"https:\/\/www.alfredivy.sg\/blogger\/2011\/03\/how-wide-is-it\/","title":{"rendered":"How wide is it?"},"content":{"rendered":"<p>I was tooling around Microsoft SQL server in preparation for a 64 bit migration when I came across this interesting command.<\/p>\n<p>xp_msver<\/p>\n<p>It returned the following for my Intel box.<\/p>\n<p>1\u00a0\u00a0 \u00a0ProductName\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0Microsoft SQL Server<br \/>\n2\u00a0\u00a0 \u00a0ProductVersion\u00a0\u00a0 \u00a0589824\u00a0\u00a0 \u00a09.00.4035.00<br \/>\n3\u00a0\u00a0 \u00a0Language\u00a0\u00a0 \u00a01033\u00a0\u00a0 \u00a0English (United States)<br \/>\n4\u00a0\u00a0 \u00a0Platform\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0NT AMD64<br \/>\n5\u00a0\u00a0 \u00a0Comments\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0NT AMD64<br \/>\n6\u00a0\u00a0 \u00a0CompanyName\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0Microsoft Corporation<br \/>\n7\u00a0\u00a0 \u00a0FileDescription\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0SQL Server Windows NT &#8211; 64 Bit<br \/>\n8\u00a0\u00a0 \u00a0FileVersion\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a02005.090.4035.00<br \/>\n9\u00a0\u00a0 \u00a0InternalName\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0SQLSERVR<br \/>\n10\u00a0\u00a0 \u00a0LegalCopyright\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0\u00a9 Microsoft Corp. All rights reserved.<br \/>\n11\u00a0\u00a0 \u00a0LegalTrademarks\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0Microsoft\u00ae is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation<br \/>\n12\u00a0\u00a0 \u00a0OriginalFilename\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0SQLSERVR.EXE<br \/>\n13\u00a0\u00a0 \u00a0PrivateBuild\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0NULL<br \/>\n14\u00a0\u00a0 \u00a0SpecialBuild\u00a0\u00a0 \u00a0264437760\u00a0\u00a0 \u00a0NULL<br \/>\n15\u00a0\u00a0 \u00a0WindowsVersion\u00a0\u00a0 \u00a0248381957\u00a0\u00a0 \u00a05.2 (3790)<br \/>\n16\u00a0\u00a0 \u00a0ProcessorCount\u00a0\u00a0 \u00a01\u00a0\u00a0 \u00a01<br \/>\n17\u00a0\u00a0 \u00a0ProcessorActiveMask\u00a0\u00a0 \u00a01\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n18\u00a0\u00a0 \u00a0ProcessorType\u00a0\u00a0 \u00a08664\u00a0\u00a0 \u00a0NULL<br \/>\n19\u00a0\u00a0 \u00a0PhysicalMemory\u00a0\u00a0 \u00a07935\u00a0\u00a0 \u00a07935 (8320720896)<br \/>\n20\u00a0\u00a0 \u00a0Product ID\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0NULL<\/p>\n<p>Interesting to see that it reports an AMD CPU.\u00a0 Checking with Google, it appears that AMD beat Intel to the 64 bit arena, as such got frozen in programming history. <a href=\"http:\/\/dbaspot.com\/forums\/sqlserver-server\/373178-xp_msver-gives-wrong-platform-64-bit-boxes.html\" target=\"_blank\">link<\/a><\/p>\n<p>Update\u00a0 19 Apr 11<br \/>\nI was wondering if any of my dark servers can take a 64 bit OS.\u00a0 This very nifty tool from VMware\u00a0 does a width check. <a href=\"http:\/\/downloads.vmware.com\/d\/details\/processor_check_5_5_dt\/JSpiQGhkYmRwKg==\" target=\"_blank\">Link<\/a><\/p>\n<p>Update 24 Jul 11<br \/>\nThe SQL version numbers reported above are not friendly to non-SQL gurus.\u00a0 This command helps a bit.<\/p>\n<blockquote><p>\u00a0Select @@version<\/p>\n<p>Microsoft SQL Server 2005 &#8211; 9.00.4035.00 (X64)\u00a0\u00a0 Nov 24 2008 16:17:31\u00a0\u00a0 Copyright (c) 1988-2005 Microsoft Corporation\u00a0 Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was tooling around Microsoft SQL server in preparation for a 64 bit migration when I came across this interesting command. xp_msver It returned the following for my Intel box. 1\u00a0\u00a0 \u00a0ProductName\u00a0\u00a0 \u00a0NULL\u00a0\u00a0 \u00a0Microsoft SQL Server 2\u00a0\u00a0 \u00a0ProductVersion\u00a0\u00a0 \u00a0589824\u00a0\u00a0 \u00a09.00.4035.00&hellip; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[213],"class_list":["post-1096","post","type-post","status-publish","format-standard","hentry","category-work","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/1096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/comments?post=1096"}],"version-history":[{"count":5,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/1096\/revisions"}],"predecessor-version":[{"id":3710,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/1096\/revisions\/3710"}],"wp:attachment":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/media?parent=1096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/categories?post=1096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/tags?post=1096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}