{"id":41512,"date":"2025-11-27T17:34:38","date_gmt":"2025-11-27T16:34:38","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=41512"},"modified":"2025-11-27T17:34:40","modified_gmt":"2025-11-27T16:34:40","slug":"common-queries-on-a-sql-server-environment-for-a-dba","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/","title":{"rendered":"Common queries on a SQL Server environment for a DBA"},"content":{"rendered":"\n<p>This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation..<\/p>\n\n\n\n<p>For this blog, you will only need SSMS and sysadmin rights on your environment.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-disk-space-problem\">Disk Space problem<\/h2>\n\n\n\n<p>If you have a full disk.<br>Instead of connecting to the server.<br>You can use this query, which will show all the disks associated with the instance.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Volume info for all LUNS that have database files on the current instance (Query 26) (Volume Info)\nSELECT DISTINCT vs.volume_mount_point, vs.file_system_type, vs.logical_volume_name,\nCONVERT(DECIMAL(18,2), vs.total_bytes\/1073741824.0) AS &#091;Total Size (GB)],\nCONVERT(DECIMAL(18,2), vs.available_bytes\/1073741824.0) AS &#091;Available Size (GB)],\nCONVERT(DECIMAL(18,2), vs.available_bytes * 1. \/ vs.total_bytes * 100.) AS &#091;Space Free %],\nvs.supports_compression, vs.is_compressed,\nvs.supports_sparse_files, vs.supports_alternate_streams\nFROM sys.master_files AS f WITH (NOLOCK)\nCROSS APPLY sys.dm_os_volume_stats(f.database_id, f.&#091;file_id]) AS vs<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"345\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png\" alt=\"\" class=\"wp-image-41621\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png 742w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7-300x139.png 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/figure>\n\n\n\n<p>If you want to see which database caused the disk to fill up, you can use this query.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE @tracepath nvarchar(260)\n\nSELECT @tracepath = path \nFROM sys.traces \nWHERE is_default = 1\n\nSELECT g.DatabaseName AS DBName\n, mf.physical_name AS DBFileName\n, CASE mf.type WHEN 0 THEN 'Row' WHEN 1 THEN 'Log' WHEN 2 THEN 'FILESTREAM' WHEN 4 THEN 'Full-text' END AS FileType\n, te.name AS EventName\n,  convert(decimal(19,2),g.IntegerData*8\/1024.)  AS AutoGrowSize\n, g.StartTime\n, convert(decimal(19,2),g.Duration\/1000.\/1000.) AS EventDuration -- Length of time necessary to extend the file.\n, CASE WHEN mf.is_percent_growth = 1 THEN CONVERT(char(2), mf.growth) + '%'\nELSE CONVERT(varchar(30), convert(decimal(19,2), mf.growth*8.\/1024.)) + 'MB' END AutoGrowSizeSetting\n, convert(decimal(19,2),mf.size* 8.\/1024.) AS fileSize\n, CASE WHEN mf.max_size = -1 THEN 'Unlimited' ELSE convert(varchar(30), convert(decimal(19,2),mf.max_size*8.\/1024.)) END AS maxFileSize\n\nFROM fn_trace_gettable(@tracepath, default) g\ncross apply sys.trace_events te \ninner join sys.master_files mf\non mf.database_id = g.DatabaseID\nand g.FileName = mf.name\nWHERE g.eventclass = te.trace_event_id\nand te.name in ('Data File Auto Grow','Log File Auto Grow')\n--GROUP BY StartTime,Databaseid, Filename, IntegerData, Duration\norder by 6 desc <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"717\" height=\"411\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-9.png\" alt=\"\" class=\"wp-image-41623\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-9.png 717w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-9-300x172.png 300w\" sizes=\"auto, (max-width: 717px) 100vw, 717px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-sid-problem-with-an-sql-login-in-an-always-on-environment\">SID problem with an SQL login in an Always On environment<\/h3>\n\n\n\n<p>As you know, when a login is created in an Always On environment, it must be created on both sides. Therefore, when it comes to an SQL login, the SID must be the same on both sides. This ensures that both logins map to the user. Pour ceci nous pouvons utiliser cette requete pour qui va donner l&#8217;exact commande a ex\u00e9cuter pour cr\u00e9e le login souhait\u00e9e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT N'CREATE LOGIN &#091;'+sp.&#091;name]+'] WITH PASSWORD=0x'+\n    CONVERT(nvarchar(max), l.password_hash, 2)+N' HASHED, '+\n    N'SID=0x'+CONVERT(nvarchar(max), sp.&#091;sid], 2)+N';'\nFROM master.sys.server_principals AS sp\nINNER JOIN master.sys.sql_logins AS l ON sp.&#091;sid]=l.&#091;sid]\nWHERE sp.name='LoginName'<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"571\" height=\"246\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-10.png\" alt=\"\" class=\"wp-image-41624\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-10.png 571w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-10-300x129.png 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-control-of-index-fragmentation-and-statistics-updates\">Control of index fragmentation and statistics updates<\/h3>\n\n\n\n<p>When performance issues arise, the first step is often to check whether all indexes have been created and are not fragmented. To do this, you can use this query to determine the level of index fragmentation.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE DatabaseName;\nGO\nSELECT S.name as 'Schema',\nT.name as 'Table',\nI.name as 'Index',\nDDIPS.avg_fragmentation_in_percent,\nDDIPS.page_count\nFROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS DDIPS\nINNER JOIN sys.tables T on T.object_id = DDIPS.object_id\nINNER JOIN sys.schemas S on T.schema_id = S.schema_id\nINNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id\nAND DDIPS.index_id = I.index_id\nWHERE DDIPS.database_id = DB_ID()\nand I.name is not null\nAND DDIPS.avg_fragmentation_in_percent &gt; 0\nORDER BY DDIPS.avg_fragmentation_in_percent desc<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"723\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-11.png\" alt=\"\" class=\"wp-image-41625\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-11.png 714w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-11-296x300.png 296w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\n\n\n\n<p>as well as this query, which indicates the last time the database statistics were updated.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE DatabaseName;<br>GO<br>SELECT 'Index Name' = i.name, 'Statistics Date' = STATS_DATE(i.object_id, i.index_id)FROM sys.objects o JOIN sys.indexes i ON o.object_id = i.object_id;<br>GO<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"495\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-12.png\" alt=\"\" class=\"wp-image-41626\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-12.png 753w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-12-300x197.png 300w\" sizes=\"auto, (max-width: 753px) 100vw, 753px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h3>\n\n\n\n<p>This is just a small part of our toolkit for getting started with debugging. In the future, other blogs more focused on everyday utility may be created. If you have any further questions or other topics you would like to discuss, please do not hesitate to contact us.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin rights on your environment. Disk Space problem If you have a full disk.Instead of connecting to the [&hellip;]<\/p>\n","protected":false},"author":85,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[99],"tags":[1528,3731,91,3734,3733,3732,51,3735],"type_dbi":[2874],"class_list":["post-41512","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-disk-full","tag-disk-space","tag-index","tag-performance-probbem","tag-sidproblem","tag-sql-login","tag-sql-server","tag-statistiques","type-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Common queries on a SQL Server environment for a DBA - dbi Blog<\/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.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Common queries on a SQL Server environment for a DBA\" \/>\n<meta property=\"og:description\" content=\"This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin rights on your environment. Disk Space problem If you have a full disk.Instead of connecting to the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-27T16:34:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-27T16:34:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"345\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Tatiana Bron\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tatiana Bron\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/\"},\"author\":{\"name\":\"Tatiana Bron\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/40ccfc7c0dd333d91c7537373ca38884\"},\"headline\":\"Common queries on a SQL Server environment for a DBA\",\"datePublished\":\"2025-11-27T16:34:38+00:00\",\"dateModified\":\"2025-11-27T16:34:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/\"},\"wordCount\":288,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/11\\\/image-7.png\",\"keywords\":[\"disk full\",\"disk space\",\"index\",\"Performance probbem\",\"SIDProblem\",\"sql login\",\"SQL Server\",\"Statistiques\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/\",\"name\":\"Common queries on a SQL Server environment for a DBA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/11\\\/image-7.png\",\"datePublished\":\"2025-11-27T16:34:38+00:00\",\"dateModified\":\"2025-11-27T16:34:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/40ccfc7c0dd333d91c7537373ca38884\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/11\\\/image-7.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/11\\\/image-7.png\",\"width\":742,\"height\":345},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/common-queries-on-a-sql-server-environment-for-a-dba\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Common queries on a SQL Server environment for a DBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/40ccfc7c0dd333d91c7537373ca38884\",\"name\":\"Tatiana Bron\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0ccdf78563fc816af2489f8514cb0150fdf043c684cd1801768acf3bb2612e0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0ccdf78563fc816af2489f8514cb0150fdf043c684cd1801768acf3bb2612e0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0ccdf78563fc816af2489f8514cb0150fdf043c684cd1801768acf3bb2612e0?s=96&d=mm&r=g\",\"caption\":\"Tatiana Bron\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/tatianabron\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Common queries on a SQL Server environment for a DBA - dbi Blog","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.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/","og_locale":"en_US","og_type":"article","og_title":"Common queries on a SQL Server environment for a DBA","og_description":"This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin rights on your environment. Disk Space problem If you have a full disk.Instead of connecting to the [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/","og_site_name":"dbi Blog","article_published_time":"2025-11-27T16:34:38+00:00","article_modified_time":"2025-11-27T16:34:40+00:00","og_image":[{"width":742,"height":345,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png","type":"image\/png"}],"author":"Tatiana Bron","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tatiana Bron","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/"},"author":{"name":"Tatiana Bron","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/40ccfc7c0dd333d91c7537373ca38884"},"headline":"Common queries on a SQL Server environment for a DBA","datePublished":"2025-11-27T16:34:38+00:00","dateModified":"2025-11-27T16:34:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/"},"wordCount":288,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png","keywords":["disk full","disk space","index","Performance probbem","SIDProblem","sql login","SQL Server","Statistiques"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/","url":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/","name":"Common queries on a SQL Server environment for a DBA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png","datePublished":"2025-11-27T16:34:38+00:00","dateModified":"2025-11-27T16:34:40+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/40ccfc7c0dd333d91c7537373ca38884"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/11\/image-7.png","width":742,"height":345},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/common-queries-on-a-sql-server-environment-for-a-dba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Common queries on a SQL Server environment for a DBA"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/40ccfc7c0dd333d91c7537373ca38884","name":"Tatiana Bron","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b0ccdf78563fc816af2489f8514cb0150fdf043c684cd1801768acf3bb2612e0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b0ccdf78563fc816af2489f8514cb0150fdf043c684cd1801768acf3bb2612e0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b0ccdf78563fc816af2489f8514cb0150fdf043c684cd1801768acf3bb2612e0?s=96&d=mm&r=g","caption":"Tatiana Bron"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/tatianabron\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=41512"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41512\/revisions"}],"predecessor-version":[{"id":41627,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41512\/revisions\/41627"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=41512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=41512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=41512"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=41512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}