SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB, SUM(a.used_pages) * 8 AS UsedSpaceKB ...

ROUND(SUM(ps.used_page_count) * 8.0 / 1024, 2) AS index_size_mb -- Calculate index size in MB FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') ips JOIN sys.indexes i ON ...

Are you looking for the solutions to repair SCCM-Server Issue From a Database? Then read this article carefully as it has all the answers that you are looking for. Microsoft SCCM (System Center ...

This part covers the SQL Server installation and configuration for a SCCM 2012 R2 environment. SQL server will be installed on a dedicated server. (If SQL server is installed on the same server as the ...

Hi all, been a long time since I've posted but I recently came back from a deployment and I'm now working in a new section doing SCCM and vulnerability management. I worked with SMS a lot and have a ...

This part covers the SQL Server installation and configuration for a SCCM 2012 R2 environment. SQL server will be installed on a dedicated server. (If SQL server is installed on the same server as the ...

I got WebDAV + SCCM + SQL working fine on 2008 (all 64bit, Std), but during setup, URL Authorization is configured globally and I'm pretty sure this is what screws up WSUS. WSUS installs fine, but the ...