{"id":9337,"date":"2022-08-03T07:41:00","date_gmt":"2022-08-03T05:41:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=9337"},"modified":"2022-11-22T14:16:45","modified_gmt":"2022-11-22T13:16:45","slug":"definition-des-partitions-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/","title":{"rendered":"D\u00e9finition des partitions SQL Server"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Quelle d\u00e9finition pour les partitions SQL Server ?<\/em><\/strong><\/h4>\n\n\n\n<p>Dans une base de donn\u00e9es SQL Server, les partitions permettent de diviser physiquement les donn\u00e9es d&rsquo;une m\u00eame table sur le ou les disques. Cette division des donn\u00e9es permet d&rsquo;acc\u00e9der directement \u00e0 une partition unique au lieu de toutes les donn\u00e9es de la table. <\/p>\n\n\n\n<p>Tout d&rsquo;abord, pourquoi toutes les grandes tables devraient-elles avoir des partitions ? Lorsque l&rsquo;on acc\u00e8de \u00e0 des centaines de millions de lignes, il devient tr\u00e8s difficile d&rsquo;obtenir un grand nombre de donn\u00e9es en quelques secondes. Les partitions permettent d&rsquo;am\u00e9liorer les performances des requ\u00eates.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#les-avantages-des-partitions-sql-server\" >Les avantages des partitions SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#definitions-des-elements-composants-les-partitions-ms-sql\" >D\u00e9finitions des \u00e9l\u00e9ments composants les partitions MS SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#un-exemple-pratique-dune-fonction-et-dun-schema-de-partition\" >Un exemple pratique d&rsquo;une fonction et d&rsquo;un sch\u00e9ma de partition<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-les-avantages-des-partitions-sql-server\"><span class=\"ez-toc-section\" id=\"les-avantages-des-partitions-sql-server\"><\/span>Les avantages des partitions SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le principal avantage d&rsquo;une table partitionn\u00e9e est \u00e9videmment d&rsquo;am\u00e9liorer les performances des requ\u00eates. Il \u00e9vite les balayages complets en ciblant uniquement les partitions n\u00e9cessaires. <\/li>\n\n\n\n<li>Les partitions de table permettent de transf\u00e9rer seulement un sous-ensemble de donn\u00e9es bas\u00e9 sur la cl\u00e9 fonctionnelle au lieu de l&rsquo;ensemble des donn\u00e9es. Prenons l&rsquo;exemple de donn\u00e9es mensuelles. La requ\u00eate transf\u00e8re uniquement le dernier mois stock\u00e9 dans une seule partition. C&rsquo;est beaucoup plus rapide que de s\u00e9lectionner l&rsquo;ensemble des donn\u00e9es, y compris l&rsquo;ann\u00e9e compl\u00e8te et les ann\u00e9es pr\u00e9c\u00e9dentes.<\/li>\n\n\n\n<li>Les partitions sur les tables permettent une maintenance beaucoup plus flexible comme la r\u00e9organisation ou la reconstruction des index.<\/li>\n<\/ul>\n\n\n\n<p>Par exemple, consid\u00e9rons un projet construit avec Microsoft Business Intelligence avec un magasin de donn\u00e9es op\u00e9rationnel, un entrep\u00f4t de donn\u00e9es, de magasins de donn\u00e9es analytiques (Data Marts) et un mod\u00e8le tabulaire SSAS. Quotidiennement, les derni\u00e8res donn\u00e9es mises \u00e0 jour pourraient n&rsquo;\u00eatre que celles du mois en cours. Il est donc plus int\u00e9ressant de ne charger que le mois en cours. Il permet \u00e9galement des suppressions et des insertions rapides pour rafra\u00eechir un ensemble de donn\u00e9es.<\/p>\n\n\n\n<p><em>Veuiller noter que toutes les versions disponibles avant et jusqu&rsquo;\u00e0 SQL Server 2012 ne supportent que jusqu&rsquo;\u00e0 1000 partitions par table.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"definitions-des-elements-composants-les-partitions-ms-sql\"><\/span>D\u00e9finitions des \u00e9l\u00e9ments composants les partitions MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>D&rsquo;autre part, le partitionnement utilise diff\u00e9rents objets SQL obligatoires : les fonctions de partition, les sch\u00e9mas de partition et les colonnes de partitionnement.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Une colonne de partitionnement<\/strong> s\u00e9pare les donn\u00e9es dans les diff\u00e9rentes partitions. Il peut s&rsquo;agir d&rsquo;une ann\u00e9e, d&rsquo;un mois ou de tout autre type de donn\u00e9es. Le choix de la colonne est bas\u00e9 sur l&rsquo;utilisation r\u00e9elle des donn\u00e9es et sur la colonne la plus utilis\u00e9e pour interroger les donn\u00e9es.<\/li>\n\n\n\n<li><strong>Une fonction de partition<\/strong> d\u00e9finit la mani\u00e8re de stocker et de mapper les donn\u00e9es sur une partition, c&rsquo;est une fonction du serveur SQL. C&rsquo;est-\u00e0-dire que sur la base d&rsquo;une colonne, la ligne compl\u00e8te sera dirig\u00e9e vers la partition 1 ou 2, etc. <\/li>\n\n\n\n<li><strong>Un sch\u00e9ma de partitionnement<\/strong> fait correspondre les partitions de donn\u00e9es \u00e0 un ensemble de fichiers physiques.<\/li>\n<\/ol>\n\n\n\n<p>Par exemple, consid\u00e9rons une <a href=\"https:\/\/langue-francaise.tv5monde.com\/decouvrir\/dictionnaire\/f\/fonction\" target=\"_blank\" rel=\"noreferrer noopener\">fonction<\/a> de partition bas\u00e9e sur le num\u00e9ro de l&rsquo;ann\u00e9e. La premi\u00e8re colonne pourrait \u00eatre celle des ann\u00e9es historiques, c&rsquo;est-\u00e0-dire avant 2018. Puis les donn\u00e9es avant 2019 et l&rsquo;ann\u00e9e 2020, puis seulement 2020 et enfin les donn\u00e9es associ\u00e9es apr\u00e8s 2020. Ainsi, l&rsquo;exemple de partition am\u00e9liore les performances des requ\u00eates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"un-exemple-pratique-dune-fonction-et-dun-schema-de-partition\"><\/span>Un exemple pratique d&rsquo;une fonction et d&rsquo;un sch\u00e9ma de partition<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Un article complet pour cr\u00e9er une table partitionn\u00e9e par ann\u00e9e, avec une fonction de partition, les groupes de fichiers, et enfin le sch\u00e9ma de partitionnement. Toutes les requ\u00eates sont disponibles dans cet article.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"JPIwKOk89d\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/table-sql-server-avec-partitions\/\">Cr\u00e9er une table SQL Server avec des partitions<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Cr\u00e9er une table SQL Server avec des partitions\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/table-sql-server-avec-partitions\/embed\/#?secret=WiZBKRrYbh#?secret=JPIwKOk89d\" data-secret=\"JPIwKOk89d\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\"><strong>Cr\u00e9er une table SQL Server avec des partitions<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Pour conclure, le premier article de la s\u00e9rie expose la d\u00e9finition des partitions SQL Server et d\u00e9finit ce qu&rsquo;est une table partitionn\u00e9e. Consulter cette s\u00e9rie sur la gestion des index et <a href=\"https:\/\/expert-only.com\/transact-sql\/creer-un-index-sql-server\/\">comment cr\u00e9er un index SQL Server<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Consulter cette foire aux questions sur les partitions de table SQL Server.<\/h4>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1659518842334\"><strong class=\"schema-faq-question\">Qu&rsquo;est-ce qu&rsquo;une table partitionn\u00e9e sous SQL Server ?<\/strong> <p class=\"schema-faq-answer\">Le partitionnement divise techniquement une table ou un index en diff\u00e9rentes parties bas\u00e9es sur les valeurs des colonnes. Les partitions sont physiquement ind\u00e9pendantes pour am\u00e9liorer les performances et faciliter la maintenance, les chargements et les transferts de donn\u00e9es. Une partition utilise une fonction de partition, un sch\u00e9ma de partition et une colonne partitionn\u00e9e.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1659518889694\"><strong class=\"schema-faq-question\">Comment partitionner une table SQL ?<\/strong> <p class=\"schema-faq-answer\">Pour partitionner une table SQL, choisir la colonne principale utilis\u00e9e dans les requ\u00eates, les chargements ou les rapports. Cr\u00e9er une fonction de partition, par exemple les mois pass\u00e9s, le mois pr\u00e9c\u00e9dent, le mois en cours et les mois futurs. Cr\u00e9er les groupes de fichiers associ\u00e9s qui seront utilis\u00e9s par le sch\u00e9ma de partition.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1659518907233\"><strong class=\"schema-faq-question\">Quelle est la diff\u00e9rence entre un index et une partition ?<\/strong> <p class=\"schema-faq-answer\">Un index structure les donn\u00e9es \u00e0 l&rsquo;int\u00e9rieur d&rsquo;une table logique. Ensuite, les administrateurs de la base de donn\u00e9es (DBA) reconstruisent et r\u00e9organisent les index. Une table partitionn\u00e9e permet de diviser physiquement les donn\u00e9es et d&rsquo;y acc\u00e9der ind\u00e9pendamment. Un index peut lui-m\u00eame \u00eatre partitionn\u00e9 pour de meilleures performances.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1659518921178\"><strong class=\"schema-faq-question\">Comment maintenir automatiquement une partition ?<\/strong> <p class=\"schema-faq-answer\">Une bonne pratique est de maintenir automatiquement la fonction de partition. Ainsi, elle cr\u00e9e les nouvelles partitions au fur et \u00e0 mesure de l&rsquo;\u00e9volution des donn\u00e9es dans le temps. Par exemple, utiliser la date courante de la base de donn\u00e9es pour ajouter chaque nouveau mois \u00e0 une partition.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Quelle d\u00e9finition pour les partitions SQL Server ? Dans une base de donn\u00e9es SQL Server, les partitions permettent de diviser physiquement les donn\u00e9es d&rsquo;une m\u00eame table sur le ou les disques. Cette division des donn\u00e9es permet d&rsquo;acc\u00e9der directement \u00e0 <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\" title=\"D\u00e9finition des partitions SQL Server\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-9337","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>D\u00e9finition des partitions SQL Server - Partitionnement T-SQL<\/title>\n<meta name=\"description\" content=\"D\u00e9finition d&#039;une partition SQL Server : le partitionnement permet de diviser les donn\u00e9es d&#039;une table et am\u00e9liorer les performances.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9finition des partitions SQL Server\" \/>\n<meta property=\"og:description\" content=\"D\u00e9finition d&#039;une partition SQL Server : le partitionnement permet de diviser les donn\u00e9es d&#039;une table et am\u00e9liorer les performances.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-03T05:41:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-22T13:16:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"D\u00e9finition des partitions SQL Server\",\"datePublished\":\"2022-08-03T05:41:00+00:00\",\"dateModified\":\"2022-11-22T13:16:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\"},\"wordCount\":962,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\",\"name\":\"D\u00e9finition des partitions SQL Server - Partitionnement T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"datePublished\":\"2022-08-03T05:41:00+00:00\",\"dateModified\":\"2022-11-22T13:16:45+00:00\",\"description\":\"D\u00e9finition d'une partition SQL Server : le partitionnement permet de diviser les donn\u00e9es d'une table et am\u00e9liorer les performances.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518842334\"},{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518889694\"},{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518907233\"},{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518921178\"}],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9finition des partitions SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518842334\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518842334\",\"name\":\"Qu'est-ce qu'une table partitionn\u00e9e sous SQL Server ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Le partitionnement divise techniquement une table ou un index en diff\u00e9rentes parties bas\u00e9es sur les valeurs des colonnes. Les partitions sont physiquement ind\u00e9pendantes pour am\u00e9liorer les performances et faciliter la maintenance, les chargements et les transferts de donn\u00e9es. Une partition utilise une fonction de partition, un sch\u00e9ma de partition et une colonne partitionn\u00e9e.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518889694\",\"position\":2,\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518889694\",\"name\":\"Comment partitionner une table SQL ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Pour partitionner une table SQL, choisir la colonne principale utilis\u00e9e dans les requ\u00eates, les chargements ou les rapports. Cr\u00e9er une fonction de partition, par exemple les mois pass\u00e9s, le mois pr\u00e9c\u00e9dent, le mois en cours et les mois futurs. Cr\u00e9er les groupes de fichiers associ\u00e9s qui seront utilis\u00e9s par le sch\u00e9ma de partition.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518907233\",\"position\":3,\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518907233\",\"name\":\"Quelle est la diff\u00e9rence entre un index et une partition ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Un index structure les donn\u00e9es \u00e0 l'int\u00e9rieur d'une table logique. Ensuite, les administrateurs de la base de donn\u00e9es (DBA) reconstruisent et r\u00e9organisent les index. Une table partitionn\u00e9e permet de diviser physiquement les donn\u00e9es et d'y acc\u00e9der ind\u00e9pendamment. Un index peut lui-m\u00eame \u00eatre partitionn\u00e9 pour de meilleures performances.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518921178\",\"position\":4,\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518921178\",\"name\":\"Comment maintenir automatiquement une partition ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Une bonne pratique est de maintenir automatiquement la fonction de partition. Ainsi, elle cr\u00e9e les nouvelles partitions au fur et \u00e0 mesure de l'\u00e9volution des donn\u00e9es dans le temps. Par exemple, utiliser la date courante de la base de donn\u00e9es pour ajouter chaque nouveau mois \u00e0 une partition.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"D\u00e9finition des partitions SQL Server - Partitionnement T-SQL","description":"D\u00e9finition d'une partition SQL Server : le partitionnement permet de diviser les donn\u00e9es d'une table et am\u00e9liorer les performances.","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:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9finition des partitions SQL Server","og_description":"D\u00e9finition d'une partition SQL Server : le partitionnement permet de diviser les donn\u00e9es d'une table et am\u00e9liorer les performances.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-08-03T05:41:00+00:00","article_modified_time":"2022-11-22T13:16:45+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"D\u00e9finition des partitions SQL Server","datePublished":"2022-08-03T05:41:00+00:00","dateModified":"2022-11-22T13:16:45+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/"},"wordCount":962,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/","name":"D\u00e9finition des partitions SQL Server - Partitionnement T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","datePublished":"2022-08-03T05:41:00+00:00","dateModified":"2022-11-22T13:16:45+00:00","description":"D\u00e9finition d'une partition SQL Server : le partitionnement permet de diviser les donn\u00e9es d'une table et am\u00e9liorer les performances.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518842334"},{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518889694"},{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518907233"},{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518921178"}],"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9finition des partitions SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518842334","position":1,"url":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518842334","name":"Qu'est-ce qu'une table partitionn\u00e9e sous SQL Server ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Le partitionnement divise techniquement une table ou un index en diff\u00e9rentes parties bas\u00e9es sur les valeurs des colonnes. Les partitions sont physiquement ind\u00e9pendantes pour am\u00e9liorer les performances et faciliter la maintenance, les chargements et les transferts de donn\u00e9es. Une partition utilise une fonction de partition, un sch\u00e9ma de partition et une colonne partitionn\u00e9e.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518889694","position":2,"url":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518889694","name":"Comment partitionner une table SQL ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Pour partitionner une table SQL, choisir la colonne principale utilis\u00e9e dans les requ\u00eates, les chargements ou les rapports. Cr\u00e9er une fonction de partition, par exemple les mois pass\u00e9s, le mois pr\u00e9c\u00e9dent, le mois en cours et les mois futurs. Cr\u00e9er les groupes de fichiers associ\u00e9s qui seront utilis\u00e9s par le sch\u00e9ma de partition.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518907233","position":3,"url":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518907233","name":"Quelle est la diff\u00e9rence entre un index et une partition ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Un index structure les donn\u00e9es \u00e0 l'int\u00e9rieur d'une table logique. Ensuite, les administrateurs de la base de donn\u00e9es (DBA) reconstruisent et r\u00e9organisent les index. Une table partitionn\u00e9e permet de diviser physiquement les donn\u00e9es et d'y acc\u00e9der ind\u00e9pendamment. Un index peut lui-m\u00eame \u00eatre partitionn\u00e9 pour de meilleures performances.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518921178","position":4,"url":"https:\/\/expert-only.com\/fr\/t-sql\/definition-des-partitions-sql-server\/#faq-question-1659518921178","name":"Comment maintenir automatiquement une partition ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Une bonne pratique est de maintenir automatiquement la fonction de partition. Ainsi, elle cr\u00e9e les nouvelles partitions au fur et \u00e0 mesure de l'\u00e9volution des donn\u00e9es dans le temps. Par exemple, utiliser la date courante de la base de donn\u00e9es pour ajouter chaque nouveau mois \u00e0 une partition.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/9337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=9337"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/9337\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10862"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=9337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=9337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=9337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}