Category: MS SQL

  • Transact-SQL Restore Latest Backup File

    Transact-SQL Restore Latest Backup File

    the very basic steps to restore latest SQL backup file on the backup media location using the below Transact-SQL statement (T-SQL Statement).

  • Analyse MS-SQL Database Memory Utilization

    In most of the development environment or staging server will not be monitored by daily. So the database auto growth can occupy countlessly. Here, we can analyze the memory utilization about the table and we can remove if the database has cache, temp or logs table. declare @t table ( name nvarchar(100), [rows] int, [reserved]…