{"id":9052,"date":"2024-03-07T06:42:59","date_gmt":"2024-03-07T05:42:59","guid":{"rendered":"https:\/\/expert-only.com\/?p=9052"},"modified":"2024-03-07T13:43:30","modified_gmt":"2024-03-07T12:43:30","slug":"taille-tables-sql-server-espace-disque","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/","title":{"rendered":"Afficher la taille des tables SQL Server sur le disque"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Comment afficher la liste des toutes les tables utilisateurs d&rsquo;une base SQL Server et leur taille avec du code T-SQL ?<\/em><\/h4>\n\n\n\n<p>Afficher la taille des tables SQL Server et l&rsquo;espace disque utilis\u00e9 physiquement est pratique pour analyser l&rsquo;utilisation de chaque table. Trois fa\u00e7ons diff\u00e9rentes, mais similaires sont pr\u00e9sent\u00e9es ici. Le but, afficher les tables SQL Server et l&rsquo;espace disque utilis\u00e9 par chaque table. La troisi\u00e8me solution montre \u00e9galement le nombre de lignes pour chaque table.<\/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\/taille-tables-sql-server-espace-disque\/#1-afficher-le-nom-de-toutes-les-tables-sql-server-et-leur-taille\" >1. Afficher le nom de toutes les tables SQL Server et leur taille<\/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\/taille-tables-sql-server-espace-disque\/#2-gerer-lespace-disque-des-bases-sql-server\" >2. G\u00e9rer l&rsquo;espace disque des bases SQL Server<\/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\/taille-tables-sql-server-espace-disque\/#3-lister-la-taille-des-tables-sql-server-avec-les-vues-systeme\" >3. Lister la taille des tables SQL Server avec les vues syst\u00e8me<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#4-lister-toutes-les-tables-ms-sql-depuis-systables\" >4. Lister toutes les tables MS SQL depuis sys.tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-afficher-le-nom-de-toutes-les-tables-sql-server-et-leur-taille\"><span class=\"ez-toc-section\" id=\"1-afficher-le-nom-de-toutes-les-tables-sql-server-et-leur-taille\"><\/span>1. Afficher le nom de toutes les tables SQL Server et leur taille<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Consulter ces requ\u00eates SQL Server pour afficher la liste des tables SQL Server et leur taille de diff\u00e9rentes mani\u00e8res. Cette premi\u00e8re requ\u00eate utilise diff\u00e9rentes tables syst\u00e8me li\u00e9es avec une jointure, \u00e0 savoir sys.tables, sys.indexes, sys.partitions, sys.allocation_units et sys.schemas.<\/p>\n\n\n\n<p>Elle affiche le nom du sch\u00e9ma, le nom de la table, le nombre de lignes et l&rsquo;<a href=\"https:\/\/gdt.oqlf.gouv.qc.ca\/ficheOqlf.aspx?Id_Fiche=8391062\" target=\"_blank\" rel=\"noreferrer noopener\">espace disque<\/a>. Soit l&rsquo;espace total, utilis\u00e9 et inutilis\u00e9 pour chaque table d&rsquo;une base SQL Server.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n     sch.name as SchemaName,\n     tab.name as TableName,\n     par.rows as RowCounts, \n     sum(alc.total_pages) * 8 as TotalSpace,\n     sum(alc.used_pages) * 8 as UsedSpace,\n     (sum(alc.total_pages) - sum(alc.used_pages)) * 8 as UnusedSpace\nFROM sys.tables tab \nINNER JOIN sys.indexes ind \n     ON tab.object_id = ind.object_id \nINNER JOIN sys.partitions par \n     ON ind.object_id = par.object_id \n     and ind.index_id = par.index_id \nINNER JOIN sys.allocation_units alc \n     ON par.partition_id = alc.container_id \nLEFT OUTER JOIN sys.schemas sch \n     ON tab.schema_id = sch.schema_id \nGROUP BY \n     tab.name, \n     sch.name, \n     par.rows \nORDER BY 1,2;\n<\/pre>\n\n\n\n<p><br>Pour aller plus loin, l&rsquo;objectif est g\u00e9n\u00e9ralement de v\u00e9rifier et de lib\u00e9rer de l&rsquo;espace disque sur le serveur h\u00e9bergeant la base de donn\u00e9es. Typiquement, lorsque le disque dur du serveur commence \u00e0 \u00eatre plein. Alors cette requ\u00eate affiche la derni\u00e8re fois qu&rsquo;une table a \u00e9t\u00e9 acc\u00e9d\u00e9e ou mise \u00e0 jour.<\/p>\n\n\n\n<p>C&rsquo;est tr\u00e8s utile avant la suppression. Par exemple, si une table n&rsquo;a pas \u00e9t\u00e9 consult\u00e9e au cours des trois derni\u00e8res ann\u00e9es, elle n&rsquo;est peut-\u00eatre plus n\u00e9cessaire.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-gerer-l-espace-disque-des-bases-sql-server\"><span class=\"ez-toc-section\" id=\"2-gerer-lespace-disque-des-bases-sql-server\"><\/span>2. G\u00e9rer l&rsquo;espace disque des bases SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, toute base de donn\u00e9es grandit, parce que le journal grandit, les donn\u00e9es grandissent, le fichier journal grandit, le fichier de sauvegarde grandit, etc. Pour rem\u00e9dier \u00e0 cela il est obligatoire de planifier des scripts de maintenance pour nettoyer les tables de log et supprimer r\u00e9guli\u00e8rement les donn\u00e9es obsol\u00e8tes, comme par exemple une p\u00e9riode de cinq ann\u00e9es glissantes pour rester en ligne.<\/p>\n\n\n\n<p>Pour des raisons de conformit\u00e9 l\u00e9gale, selon le domaine d&rsquo;activit\u00e9, il peut \u00eatre n\u00e9cessaire de conserver et de sauvegarder les donn\u00e9es plus longtemps.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-lister-la-taille-des-tables-sql-server-avec-les-vues-systeme\"><span class=\"ez-toc-section\" id=\"3-lister-la-taille-des-tables-sql-server-avec-les-vues-systeme\"><\/span>3. Lister la taille des tables SQL Server avec les vues syst\u00e8me<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cette approche consiste \u00e0 utiliser les donn\u00e9es stock\u00e9es dans le sch\u00e9ma information_schema concernant les tables. La requ\u00eate Microsoft SQL utilise la table syst\u00e8me information_schema.tables pour afficher tous les attributs et m\u00e9tadonn\u00e9es de la base de donn\u00e9es syst\u00e8me.<\/p>\n\n\n\n<p>Elle affiche les quatre colonnes disponibles dans la vue syst\u00e8me des tables :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TABLE_CATALOG est le nom de la base de donn\u00e9es.<\/li>\n\n\n\n<li>TABLE_SCHEMA est le sch\u00e9ma h\u00e9bergeant la table, par d\u00e9faut il s&rsquo;agit du propri\u00e9taire de la base de donn\u00e9es (dbo).<\/li>\n\n\n\n<li>TABLE_NAME est le nom de la table.<\/li>\n\n\n\n<li>TABLE_TYPE est le type de la table.<\/li>\n<\/ul>\n\n\n\n<p>Notez que nous filtrons la requ\u00eate sur la vue pour afficher uniquement le type de table de base. D&rsquo;autres types de tables peuvent \u00e9galement \u00eatre affich\u00e9s.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT \n     TABLE_CATALOG, \n     TABLE_SCHEMA, \n     TABLE_NAME, \n     TABLE_TYPE\nFROM \tinformation_schema.tables\nWHERE \ttable_type='base table';\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-lister-toutes-les-tables-ms-sql-depuis-sys-tables\"><span class=\"ez-toc-section\" id=\"4-lister-toutes-les-tables-ms-sql-depuis-systables\"><\/span>4. Lister toutes les tables MS SQL depuis sys.tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La derni\u00e8re requ\u00eate utilise la table syst\u00e8me sys.tables, elle est certainement la source de la vue syst\u00e8me utilis\u00e9e dans la premi\u00e8re requ\u00eate. Elle montre beaucoup plus d&rsquo;informations et de m\u00e9tadonn\u00e9es. Comme les donn\u00e9es de cr\u00e9ation, la date de modification, et l&rsquo;object_id r\u00e9utilisable dans d&rsquo;autres fonctions et proc\u00e9dures du syst\u00e8me.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Utiliser la table syst\u00e8me sys.tables\nSELECT \t*\nFROM \tsys.tables\nWHERE \t[type_desc] = 'USER_TABLE';\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En conclusion, cet article de blog pr\u00e9sente plusieurs m\u00e9thodes pour afficher la liste de toutes les tables utilisateurs d&rsquo;une base SQL Server et leur taille. L&rsquo;affichage de la taille des tables et de l&rsquo;espace disque utilis\u00e9 est utile pour analyser l&rsquo;utilisation de chaque table, ce qui peut aider \u00e0 optimiser l&rsquo;espace disque et am\u00e9liorer les performances de la base de donn\u00e9es.<\/p>\n\n\n\n<p>Les requ\u00eates SQL pr\u00e9sent\u00e9es dans l&rsquo;article permettent d&rsquo;obtenir des informations sur les tables en utilisant diff\u00e9rentes vues syst\u00e8me et tables syst\u00e8me de SQL Server. En utilisant ces requ\u00eates, les administrateurs de base de donn\u00e9es peuvent mieux comprendre l&rsquo;utilisation de leur base de donn\u00e9es et prendre des mesures pour l&rsquo;optimiser.<\/p>\n\n\n\n<p>Pour aller plus loin dans le sujet de la maintenance des bases de donn\u00e9es SQL Server, consultez ce court tutoriel pour <a href=\"https:\/\/expert-only.com\/fr\/dba\/vider-le-journal-des-transactions\/\">lib\u00e9rer de l&rsquo;espace disque avec un script SQL Shrink Database<\/a>.<\/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=\"Bx2Sk6lrRb\"><a href=\"https:\/\/expert-only.com\/fr\/dba\/vider-le-journal-des-transactions\/\">Vider le journal des transactions SQL Server<\/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\u00a0Vider le journal des transactions SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/dba\/vider-le-journal-des-transactions\/embed\/#?secret=Z1LYiopD8O#?secret=Bx2Sk6lrRb\" data-secret=\"Bx2Sk6lrRb\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment afficher la liste des toutes les tables utilisateurs d&rsquo;une base SQL Server et leur taille avec du code T-SQL ? Afficher la taille des tables SQL Server et l&rsquo;espace disque utilis\u00e9 physiquement est pratique pour analyser l&rsquo;utilisation de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\" title=\"Afficher la taille des tables SQL Server sur le disque\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10817,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-9052","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>Afficher la taille des tables SQL Server - T-SQL - MS SQL<\/title>\n<meta name=\"description\" content=\"Afficher la taille des tables SQL Server et l&#039;espace disque utilis\u00e9 avec ces requ\u00eates simples pour lister les tables et le nombre de lignes.\" \/>\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\/taille-tables-sql-server-espace-disque\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Afficher la taille des tables SQL Server sur le disque\" \/>\n<meta property=\"og:description\" content=\"Afficher la taille des tables SQL Server et l&#039;espace disque utilis\u00e9 avec ces requ\u00eates simples pour lister les tables et le nombre de lignes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\" \/>\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=\"2024-03-07T05:42:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-07T12:43:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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=\"4 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\/taille-tables-sql-server-espace-disque\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Afficher la taille des tables SQL Server sur le disque\",\"datePublished\":\"2024-03-07T05:42:59+00:00\",\"dateModified\":\"2024-03-07T12:43:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\"},\"wordCount\":798,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\",\"name\":\"Afficher la taille des tables SQL Server - T-SQL - MS SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"datePublished\":\"2024-03-07T05:42:59+00:00\",\"dateModified\":\"2024-03-07T12:43:30+00:00\",\"description\":\"Afficher la taille des tables SQL Server et l'espace disque utilis\u00e9 avec ces requ\u00eates simples pour lister les tables et le nombre de lignes.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Afficher la taille des tables SQL Server sur le disque\"}]},{\"@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\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Afficher la taille des tables SQL Server - T-SQL - MS SQL","description":"Afficher la taille des tables SQL Server et l'espace disque utilis\u00e9 avec ces requ\u00eates simples pour lister les tables et le nombre de lignes.","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\/taille-tables-sql-server-espace-disque\/","og_locale":"fr_FR","og_type":"article","og_title":"Afficher la taille des tables SQL Server sur le disque","og_description":"Afficher la taille des tables SQL Server et l'espace disque utilis\u00e9 avec ces requ\u00eates simples pour lister les tables et le nombre de lignes.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-07T05:42:59+00:00","article_modified_time":"2024-03-07T12:43:30+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Afficher la taille des tables SQL Server sur le disque","datePublished":"2024-03-07T05:42:59+00:00","dateModified":"2024-03-07T12:43:30+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/"},"wordCount":798,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/","name":"Afficher la taille des tables SQL Server - T-SQL - MS SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","datePublished":"2024-03-07T05:42:59+00:00","dateModified":"2024-03-07T12:43:30+00:00","description":"Afficher la taille des tables SQL Server et l'espace disque utilis\u00e9 avec ces requ\u00eates simples pour lister les tables et le nombre de lignes.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Afficher la taille des tables SQL Server sur le disque"}]},{"@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"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/9052","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=9052"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/9052\/revisions"}],"predecessor-version":[{"id":30594,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/9052\/revisions\/30594"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10817"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=9052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=9052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=9052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}