{"id":2345,"date":"2018-06-16T10:34:20","date_gmt":"2018-06-16T08:34:20","guid":{"rendered":"https:\/\/bob-team.de\/wordpress\/?p=2345"},"modified":"2018-06-16T10:34:20","modified_gmt":"2018-06-16T08:34:20","slug":"plattenplatz-ms-sql-server","status":"publish","type":"post","link":"https:\/\/bob-team.de\/wordpress\/2018\/06\/16\/plattenplatz-ms-sql-server\/","title":{"rendered":"Plattenplatz MS SQL Server"},"content":{"rendered":"<pre lang=\"sql\">USE abcdb\r\n\r\nDECLARE @table \r\n  table(Id int IDENTITY(1,1), Name varchar(256))\r\n\r\nINSERT INTO @table\r\n  SELECT b.name + '.'+ a.name\r\n  FROM sys.tables a INNER JOIN sys.schemas b\r\n  ON a.schema_id = b.schema_id\r\n\r\nINSERT INTO @table\r\nSELECT '-1'\r\n\r\nDECLARE @result table(TableName varchar(256)\r\n, TotalRows int\r\n, Reserved varchar(50)\r\n, DataSize varchar(50)\r\n, IndexSize varchar(50)\r\n, UnusedSize varchar(50))\r\n\r\nDECLARE @temp varchar(256)\r\nDECLARE @index int\r\nSET @index = 1\r\n\r\nWHILE 1=1\r\nBEGIN\r\n  SELECT @temp = Name FROM @table\r\n  WHERE Id = @index\r\n\r\n  IF @temp = '-1' BREAK\t\r\n\r\n  INSERT @result(TableName\r\n  , TotalRows\r\n  , Reserved\r\n  , DataSize\r\n  , IndexSize\r\n  , UnusedSize)\r\n  EXEC sp_spaceused @temp\r\n\r\n  SET @index = @index + 1\r\nEND\r\n\r\nSELECT c.name+'.'+b.name as [table], a.*\r\nFROM @result a\r\nINNER JOIN sys.tables b ON a.TableName = b.name\r\nINNER JOIN sys.schemas c ON b.schema_id = c.schema_id\r\nORDER BY TotalRows DESC<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>USE abcdb DECLARE @table table(Id int IDENTITY(1,1), Name varchar(256)) INSERT INTO @table SELECT b.name + &#8218;.&#8217;+ a.name FROM sys.tables a INNER JOIN sys.schemas b ON a.schema_id = b.schema_id INSERT INTO @table SELECT &#8218;-1&#8216; DECLARE @result table(TableName varchar(256) , TotalRows int , Reserved varchar(50) , DataSize varchar(50) , IndexSize varchar(50) , UnusedSize varchar(50)) DECLARE @temp varchar(256) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[72],"class_list":["post-2345","post","type-post","status-publish","format-standard","hentry","category-skripte","tag-mssql","entry"],"_links":{"self":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/2345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/comments?post=2345"}],"version-history":[{"count":1,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/2345\/revisions"}],"predecessor-version":[{"id":2346,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/2345\/revisions\/2346"}],"wp:attachment":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/media?parent=2345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/categories?post=2345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/tags?post=2345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}