Skip to content

Tajuzzaman

penulis code alam maya

Tajuzzaman

penulis code alam maya

  • Home
  • Profile
  • Product
    • AuroraHRM
    • AuroraPDMS
    • Outsourcing
    • Mobile App
    • Software Integration
  • Privacy
  • Blog
  • Contact
    • Home
    • Database
Database

MSSQL Shrink Database and Database Log

tajuzzaman February 17, 2024 0 Comments

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,…

Database

SQL Server Management Studio – Displaying Line Number SSMS

tajuzzaman October 1, 2023 0 Comments

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…

Database

Ultimate MSSQL Databases Cheatsheet

tajuzzaman September 18, 2023 0 Comments

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,…

Author

Tajuzzaman

Tajuzzaman

Categories

  • AuroraHRM (1)
  • Computer (2)
  • Database (3)
  • Flutter (5)
  • Google Cloud (4)
  • Guitar Tab (4)
  • Internet (6)
  • Linux (3)
  • Makan Mana (1)
  • Programming (9)
  • Sembang Bola (5)
  • Travelog (6)

Other Project

  • Tajuzzaman.my
  • Aurora Cloud Works
  • Kelabu Ventures Store

Archieves

  • August 2024
  • July 2024
  • April 2024
  • March 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • August 2023

You Missed

AuroraHRM

Mudahnya HR software dan Gaji (Payroll) dengan AuroraHRM

Travelog

Spider Keluar Sarang dengan lagu baru 2024 – Official Lirik

Travelog

Senarai Cuti Umum 2025 (Public Holiday) Malaysia

Travelog

Uniqlo UT x Harry Potter Collection

Tajuzzaman

penulis code alam maya

Copyright © Tajuzzaman.com | Product of Kelabu Ventures.

  • Home
  • Profile
  • Product
    • AuroraHRM
    • AuroraPDMS
    • Outsourcing
    • Mobile App
    • Software Integration
  • Privacy
  • Blog
  • Contact