Ams627

SELECT 
    t.name AS TableName,
    SUM(ps.row_count) AS [RowCount],
    SUM(ps.used_page_count) * 8 AS [UsedSpaceKB],
    SUM(ps.reserved_page_count) * 8 AS [ReservedSpaceKB]
FROM sys.dm_db_partition_stats AS ps
JOIN sys.tables AS t ON ps.object_id = t.object_id
GROUP BY t.name
ORDER BY [UsedSpaceKB] DESC;

Ams627

SELECT 
    t.name AS TableName,
    SUM(ps.row_count) AS [RowCount],
    SUM(ps.used_page_count) * 8 AS [UsedSpaceKB],
    SUM(ps.reserved_page_count) * 8 AS [ReservedSpaceKB]
FROM sys.dm_db_partition_stats AS ps
JOIN sys.tables AS t ON ps.object_id = t.object_id
WHERE t.name = N'MyTable'
GROUP BY t.name;

Ams627

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS;
EXEC sp_spaceused N'dbo.MyTable';

Ams627

EXEC sp_spaceused N'dbo.MyTable';

Ams627

<Project>
    <PropertyGroup>
        <Dog>$(Configuration)</Dog>
    </PropertyGroup>
</Project>

Ams627

<Project>
  <Target Name="ShowTfmForRestore" BeforeTargets="Restore">
    <Message Importance="High" Text="TFM: $(TargetFramework)" />
    <Message Importance="High" Text="TFMs: $(TargetFrameworks)" />
    <Message Importance="High" Text="ImportDirectoryBuildProps=$(ImportDirectoryBuildProps)" />
    <Message Importance="High" Text="Project: $(MSBuildProjectFullPath)" />
  </Target>
</Project>

Ams627

<Message
  Text="Metadata list: @(AssemblyMetadata->'%(Identity)=%(Value)', ', ')" />

Ams627

<Message Text="Metadata list for %(AssemblyMetadata.Identity): Value=%(AssemblyMetadata.Value) OtherMeta=%(AssemblyMetadata.OtherMeta)" />

Ams627

<Project>
  <PropertyGroup>
    <AppendTargetFrameworkToOutputPath>true</AppendTargetFrameworkToOutputPath>
    <AppendRuntimeIdentifierToOutputPath>true</AppendRuntimeIdentifierToOutputPath>
    <OutputType>Exe</OutputType>
    <TargetFrameworks>net8.0-windows</TargetFrameworks>
    <PlatformTarget>x64</PlatformTarget>
    <DebugType>Embedded</DebugType>
    <LangVersion>Latest</LangVersion>
    <UseArtifactsOutput>true</UseArtifactsOutput>

Ams627

auto a = authors, e = expected;
std::sort(a.begin(), a.end(), /* comparator */);
std::sort(e.begin(), e.end(), /* comparator */);
EXPECT_EQ(a, e);