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