SQL: List Rows with at least One NULL Value
tajuzzamanDuring data audits, migrations, or quality checks, it’s often necessary to identify records that contain at least one NULL value. When a table has many columns, manually writing OR column…
MSSQL Shrink Database and Database Log
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,…
SQL Server Management Studio – Displaying Line Number SSMS
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…
Ultimate MSSQL Databases Cheatsheet
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,…