Clota Blog

Category: Backup Tools for SQL Server

  • Important SQL Server Scripts…

    Restore Progress Check… ========================================================================== DECLARE @DBName VARCHAR(64) = ‘ODS’ DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX)) INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery of database’, @DBName INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery completed’, @DBName SELECT TOP 1     @DBName AS [DBName]    ,[LogDate]    ,CASE       WHEN…

  • ACID Properties of RDBMS

     Hii guys, I hope you are doing great, Today here I am going to explain you about the ACID properties of RDBMS and its types. Transaction- Any operation that reads from or writes to a database is referred to as a transaction in relational databases. A transaction is a logical unit of work that can…

  • ALL About TempDB

    For TempDB –Determining the amount of free space in tempdb USE tempdb;  SELECT SUM(unallocated_extent_page_count) AS [free pages],   (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]  FROM sys.dm_db_file_space_usage; –Determining the Amount of Space Used by User Objects USE tempdb;  SELECT SUM(user_object_reserved_page_count) AS [user object pages used],  (SUM(user_object_reserved_page_count)*1.0/128) AS [user object space in MB]  FROM sys.dm_db_file_space_usage; use tempdb  SELECT GETDATE() AS runtime     ,(SUM(user_object_reserved_page_count) * 8)/1024 AS usr_obj_mb     ,SUM(internal_object_reserved_page_count) * 8 AS internal_obj_kb     ,(SUM(version_store_reserved_page_count) * 8)/1024 AS version_store_mb     ,(SUM(unallocated_extent_page_count) * 8)/1024 AS freespace_mb     ,(SUM(mixed_extent_page_count) * 8)/1024 AS mixedextent_mb FROM sys.dm_db_file_space_usage use tempdb   SELECT session_id,     SUM(internal_objects_alloc_page_count) AS NumOfPagesAllocatedInTempDBforInternalTask,     SUM(internal_objects_dealloc_page_count) AS NumOfPagesDellocatedInTempDBforInternalTask,     SUM(user_objects_alloc_page_count) AS NumOfPagesAllocatedInTempDBforUserTask,     SUM(user_objects_dealloc_page_count) AS NumOfPagesDellocatedInTempDBforUserTask FROM sys.dm_db_task_space_usage GROUP BY session_id ORDER BY NumOfPagesAllocatedInTempDBforInternalTask DESC, NumOfPagesAllocatedInTempDBforUserTask DESC…