MSSQL Shrink Database and Database Log Command -- the database USE YourDatabaseName; GO -- Shrink the data file DBCC SHRINKDATABASE (YourDatabaseName); GO -- Shrink the log file DBCC SHRINKFILE (YourLogFileName,…
Sebagai pembangun sistem HR (AuroraHRM), script maintenance database kami mempunyai beribu line untuk setiap versi. Terutama code melibatkan Stored Procedure pemprosesan pengiraan gaji, pengiraan cukai, pembayaran kerja lebih masa dan…
1. Get Size of All Table in a Database SELECT t.name AS TableName, s.name AS SchemaName, p.rows, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36,…
tajuzzaman