{"id":692,"date":"2012-07-11T12:11:00","date_gmt":"2012-07-11T12:11:00","guid":{"rendered":"\/post\/1391\/04\/21\/SQLServer20120Training"},"modified":"2012-07-11T12:11:00","modified_gmt":"2012-07-11T12:11:00","slug":"%d8%ac%d9%84%d8%b3%d9%87-%d8%aa%d9%88%d8%ac%db%8c%d9%87%db%8c-%d8%af%d9%88%d8%b1%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%aa%d8%ae%d8%b5%d8%b5%db%8c-sql-server-2012","status":"publish","type":"post","link":"https:\/\/mesbahi.net\/fa\/blog\/1391\/04\/21\/%d8%ac%d9%84%d8%b3%d9%87-%d8%aa%d9%88%d8%ac%db%8c%d9%87%db%8c-%d8%af%d9%88%d8%b1%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%aa%d8%ae%d8%b5%d8%b5%db%8c-sql-server-2012\/","title":{"rendered":"\u062c\u0644\u0633\u0647 \u062a\u0648\u062c\u06cc\u0647\u06cc \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634 \u062a\u062e\u0635\u0635\u06cc SQL Server 2012"},"content":{"rendered":"<p><a href=\"$SQL-banner4.jpg\"><img decoding=\"async\" src=\"\/IMAGES%2fSQL-banner.jpg.jpgx\" alt=\"\" \/><\/a><\/p>\n<p>\u062e\u0648\u0634\u062d\u0627\u0644\u0645 \u06a9\u0647 \u0641\u0631\u0635\u062a\u06cc \u062f\u0633\u062a \u062f\u0627\u062f\u0647 \u062a\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u062a\u0648\u0646\u0645 \u062f\u0631 \u062e\u062f\u0645\u062a \u062f\u0648\u0633\u062a\u0627\u0646 \u0628\u0627\u0634\u0645 \u0648\u0644\u06cc \u0627\u06cc\u0646\u0628\u0627\u0631 \u0628\u0627 \u062f\u0648\u0631\u0647 SQL Server 2012.<\/p>\n<p>\u062a\u062c\u0631\u0628\u0647 \u06cc \u0686\u0646\u062f\u06cc\u0646 \u0633\u0627\u0644\u0647 \u06af\u0630\u0634\u062a\u0647 \u062b\u0627\u0628\u062a \u06a9\u0631\u062f\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc \u06a9\u0647 \u062f\u0648\u0631\u0647 Development \u0631\u0648 \u0634\u0631\u06a9\u062a \u0645\u06cc\u06a9\u0646\u0646\u062f\u060c \u0639\u0645\u0648\u0645\u0627 \u0628\u0647 \u0633\u0645\u062a \u062f\u0648\u0631\u0647 Administration \u0646\u062e\u0648\u0627\u0647\u0646\u062f \u0627\u0648\u0645\u062f \u0648 \u0628\u0644\u0639\u06a9\u0633.. \u0648 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u062e\u06cc\u0644\u06cc \u0645\u0647\u0645\u0647 \u06a9\u0647 \u0647\u06cc\u0686 \u0627\u062f\u0645\u06cc\u0646\u06cc \u0646\u0645\u06cc\u062a\u0648\u0646\u0647 \u0645\u0648\u0641\u0642 \u0628\u0627\u0634\u0647 \u0645\u06af\u0631 \u0627\u06cc\u0646\u06a9\u0647 Development \u0631\u0648 \u0645\u0633\u0644\u0637 \u0628\u0627\u0634\u0647\u060c \u0686\u0631\u0627 \u06a9\u0647 \u0628\u0627\u0648\u0631 \u0645\u0627 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0627\u062f\u0645\u06cc\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 (DBA) \u0647\u0631\u06af\u0632 \u0646\u0628\u0627\u06cc\u062f \u0633\u0637\u062d\u0634 \u062f\u0631 \u062d\u062f \u06cc\u06a9 \u0628\u06a9\u0627\u067e \u06af\u06cc\u0631 \u067e\u0627\u06cc\u06cc\u0646 \u0628\u06cc\u0627\u062f&hellip; Tuning \u0648 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u06af\u0644\u0648\u06af\u0627\u0647 \u0647\u0627\u06cc Performance \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u06af\u0631\u0648 \u062f\u0627\u0646\u0634 Development \u0627\u0633\u062a&hellip; \u0627\u0632 \u0637\u0631\u0641\u06cc Developer\u06cc \u06a9\u0647 \u062f\u0627\u0646\u0634 \u0646\u0635\u0628 \u0648 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0648 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0648 \u0646\u062f\u0627\u0631\u0647 \u0647\u0645 \u0628\u0627 \u0645\u0634\u06a9\u0644\u0627\u062a \u0645\u062a\u0639\u062f\u062f\u06cc \u0631\u0648\u0628\u0631\u0648 \u0627\u0633\u062a.<\/p>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0627\u0644 \u0631\u0648 \u0627\u0632 SQL Server 2000 \u0628\u0647 \u0628\u0639\u062f \u0634\u0631\u0648\u0639 \u06a9\u0631\u062f\u0645\u060c \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648 \u0628\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u062f\u0648\u0631\u0647 \u0647\u0627\u06cc Development \u0648 Administration \u0645\u0646\u0637\u0628\u0642 \u0628\u0627 \u0633\u0631\u0641\u0635\u0644 \u0647\u0627\u06cc Microsoft \u0633\u0639\u06cc \u062e\u0648\u0627\u0647\u0645 \u062f\u0627\u0634\u062a \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u062e\u06cc\u0644\u06cc \u062e\u0648\u0628\u06cc \u06a9\u0647 \u062f\u0631 \u062f\u0648\u0631\u0647 \u0647\u0627\u06cc SQL Server 2005 \u0648 SQL Server 2008 \u062f\u0627\u0634\u062a\u06cc\u0645 \u0631\u0648 \u0627\u06cc\u0646\u0628\u0627\u0631 \u0628\u0627 SQL Server 2012 \u062a\u062c\u0631\u0628\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u062c\u0644\u0633\u0647 \u062a\u0648\u062c\u06cc\u0647\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0634\u0627\u0645\u0644 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<ul>\n<li>&nbsp;&nbsp; \u0686\u0631\u0627 SQL Server 2012\u061f<\/li>\n<li>&nbsp;&nbsp; \u062a\u0648\u0636\u06cc\u062d \u062f\u0631\u0628\u0627\u0631\u0647 \u062a\u0645\u0627\u0645\u06cc \u0633\u0631\u0641\u0635\u0644 \u0647\u0627\u06cc \u062f\u0648\u0631\u0647\u060c \u0628\u0647 \u06af\u0648\u0646\u0647 \u0627\u06cc \u06a9\u0647 \u062f\u0627\u0646\u0634\u062c\u0648 \u0628\u062f\u0627\u0646\u062f \u0686\u0647 \u0641\u0635\u0644\u06cc \u062f\u0631\u0628\u0627\u0631\u0647 \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0628\u062d\u062b \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f \u0648 \u0645\u062b\u0644\u0627 \u0627\u06af\u0631 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0635\u0644 Replication \u06cc\u0627 Column Stored Index \u0627\u0633\u062a\u060c \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u0686\u06cc \u0647\u0633\u062a\u0646\u062f \u0648 \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0645\u06cc\u0634\u0647 \u0628\u0647 \u0648\u0633\u06cc\u0644\u0647 \u0622\u0646\u0647\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f&hellip;<\/li>\n<li>&nbsp;&nbsp; \u0686\u0647 \u06a9\u0633\u0627\u0646\u06cc \u0646\u0628\u0627\u06cc\u062f \u062f\u0631 \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0634\u0631\u06a9\u062a \u06a9\u0646\u0646\u062f\u061f<\/li>\n<li>&nbsp;&nbsp; \u062a\u0645\u0627\u0631\u06cc\u0646\u060c \u0627\u0645\u062a\u062d\u0627\u0646\u0627\u062a \u0648 \u067e\u0631\u0648\u0698\u0647 \u06cc \u062f\u0648\u0631\u0647 \u0628\u0647 \u0686\u0647 \u0646\u062d\u0648\u06cc \u0627\u0633\u062a \u0648 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0686\u0642\u062f\u0631 \u0628\u0627\u06cc\u062f \u0648\u0642\u062a \u0628\u06af\u0630\u0627\u0631\u06cc\u062f\u061f<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\">\u0627\u06cc\u0646 \u062c\u0644\u0633\u0647\u060c \u0641\u0631\u062f\u0627 5\u0634\u0646\u0628\u0647 22\u062a\u06cc\u0631 \u0645\u0627\u0647 \u062f\u0631 \u0645\u062d\u0644 \u0645\u0648\u0633\u0633\u0647 \u0622\u0645\u0648\u0634\u06cc \u0686\u06a9\u0627\u062f \u0627\u0632 \u0633\u0627\u0639\u062a 14 \u062a\u0627 16 \u0628\u0631\u06af\u0632\u0627\u0631 \u062e\u0648\u0627\u0647\u0645 \u06a9\u0631\u062f\u060c \u0627\u06cc\u0646 \u062c\u0644\u0633\u0647 \u0631\u0627\u06cc\u06af\u0627\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/span><span style=\"color: #666666;\"> (\u0628\u0644\u0648\u0627\u0631 \u06a9\u0634\u0627\u0648\u0631\u0632 \u060c \u062e\u06cc\u0627\u0628\u0627\u0646 \u0642\u062f\u0633 \u060c \u0628\u06cc\u0646 \u062e \u0627\u06cc\u062a\u0627\u0644\u06cc\u0627 \u0648 \u06a9\u0648\u06cc \u0641\u0631\u062f\u0627\u0646\u0634 \u060c \u067e\u0644\u0627\u06a9 25 \u060c \u0637\u0628\u0642\u0647 \u0686\u0647\u0627\u0631\u0645 \u060c \u0634\u0631\u06a9\u062a \u0686\u06a9\u0627\u062f)<\/span><\/p>\n<p><span style=\"color: #ff0000;\"><a href=\"http:\/\/www.chakad-it.com\/\u062a\u0645\u0627\u0633\u0628\u0627\u0645\u0627.aspx\" target=\"_blank\" rel=\"noopener\">\u0627\u062f\u0631\u0633\u060c \u062a\u0644\u0641\u0646 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0646\u0642\u0634\u0647 \u06a9\u0631\u0648\u06a9\u06cc \u062f\u0631 \u0627\u06cc\u0646 \u0644\u06cc\u0646\u06a9<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u062e\u0648\u0634\u062d\u0627\u0644\u0645 \u06a9\u0647 \u0641\u0631\u0635\u062a\u06cc \u062f\u0633\u062a \u062f\u0627\u062f\u0647 \u062a\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u062a\u0648\u0646\u0645 \u062f\u0631 \u062e\u062f\u0645\u062a \u062f\u0648\u0633\u062a\u0627\u0646 \u0628\u0627\u0634\u0645 \u0648\u0644\u06cc \u0627\u06cc\u0646\u0628\u0627\u0631 \u0628\u0627 \u062f\u0648\u0631\u0647 SQL Server 2012. \u062a\u062c\u0631\u0628\u0647 \u06cc \u0686\u0646\u062f\u06cc\u0646 \u0633\u0627\u0644\u0647 \u06af\u0630\u0634\u062a\u0647 \u062b\u0627\u0628\u062a \u06a9\u0631\u062f\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc \u06a9\u0647 \u062f\u0648\u0631\u0647 Development \u0631\u0648 \u0634\u0631\u06a9\u062a \u0645\u06cc\u06a9\u0646\u0646\u062f\u060c \u0639\u0645\u0648\u0645\u0627 \u0628\u0647 \u0633\u0645\u062a \u062f\u0648\u0631\u0647 Administration \u0646\u062e\u0648\u0627\u0647\u0646\u062f \u0627\u0648\u0645\u062f \u0648 \u0628\u0644\u0639\u06a9\u0633.. \u0648 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u062e\u06cc\u0644\u06cc \u0645\u0647\u0645\u0647 \u06a9\u0647 \u0647\u06cc\u0686 \u0627\u062f\u0645\u06cc\u0646\u06cc \u0646\u0645\u06cc\u062a\u0648\u0646\u0647 \u0645\u0648\u0641\u0642 \u0628\u0627\u0634\u0647 \u0645\u06af\u0631 \u0627\u06cc\u0646\u06a9\u0647 &#8230; <a title=\"\u062c\u0644\u0633\u0647 \u062a\u0648\u062c\u06cc\u0647\u06cc \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634 \u062a\u062e\u0635\u0635\u06cc SQL Server 2012\" class=\"read-more\" href=\"https:\/\/mesbahi.net\/fa\/blog\/1391\/04\/21\/%d8%ac%d9%84%d8%b3%d9%87-%d8%aa%d9%88%d8%ac%db%8c%d9%87%db%8c-%d8%af%d9%88%d8%b1%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%aa%d8%ae%d8%b5%d8%b5%db%8c-sql-server-2012\/\" aria-label=\"\u062f\u0631\u0628\u0627\u0631\u06c0 \u062c\u0644\u0633\u0647 \u062a\u0648\u062c\u06cc\u0647\u06cc \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634 \u062a\u062e\u0635\u0635\u06cc SQL Server 2012 \u0628\u06cc\u0634\u062a\u0631 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f\">\u0627\u062f\u0627\u0645\u0647<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[5,9],"tags":[],"class_list":["post-692","post","type-post","status-publish","format-standard","hentry","category-sqlserver","category-9"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"\u0627\u0645\u06cc\u0646 \u0645\u0635\u0628\u0627\u062d\u06cc","author_link":"https:\/\/mesbahi.net\/fa\/blog\/author\/amin\/"},"uagb_comment_info":0,"uagb_excerpt":"\u062e\u0648\u0634\u062d\u0627\u0644\u0645 \u06a9\u0647 \u0641\u0631\u0635\u062a\u06cc \u062f\u0633\u062a \u062f\u0627\u062f\u0647 \u062a\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u062a\u0648\u0646\u0645 \u062f\u0631 \u062e\u062f\u0645\u062a \u062f\u0648\u0633\u062a\u0627\u0646 \u0628\u0627\u0634\u0645 \u0648\u0644\u06cc \u0627\u06cc\u0646\u0628\u0627\u0631 \u0628\u0627 \u062f\u0648\u0631\u0647 SQL Server 2012. \u062a\u062c\u0631\u0628\u0647 \u06cc \u0686\u0646\u062f\u06cc\u0646 \u0633\u0627\u0644\u0647 \u06af\u0630\u0634\u062a\u0647 \u062b\u0627\u0628\u062a \u06a9\u0631\u062f\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc \u06a9\u0647 \u062f\u0648\u0631\u0647 Development \u0631\u0648 \u0634\u0631\u06a9\u062a \u0645\u06cc\u06a9\u0646\u0646\u062f\u060c \u0639\u0645\u0648\u0645\u0627 \u0628\u0647 \u0633\u0645\u062a \u062f\u0648\u0631\u0647 Administration \u0646\u062e\u0648\u0627\u0647\u0646\u062f \u0627\u0648\u0645\u062f \u0648 \u0628\u0644\u0639\u06a9\u0633.. \u0648 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u062e\u06cc\u0644\u06cc \u0645\u0647\u0645\u0647 \u06a9\u0647 \u0647\u06cc\u0686 \u0627\u062f\u0645\u06cc\u0646\u06cc \u0646\u0645\u06cc\u062a\u0648\u0646\u0647 \u0645\u0648\u0641\u0642 \u0628\u0627\u0634\u0647 \u0645\u06af\u0631 \u0627\u06cc\u0646\u06a9\u0647&hellip;","_links":{"self":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts\/692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":0,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"wp:attachment":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}