When we require executing same T-SQL command for all the tables, we can use this stored procedure. Many times we
Category: SQL SERVER
084. sql server Script to find the Forwarded Records count of a Table
In the below script, you can add a filter of your database and table for getting the number of Forwarding
083. SQL Server 2014 Monitor Memory Optimized Tables which stored in Memory
SQL Server 2014 introduced the concept of In-Memory Database which provides the best combination of RDBMS + In-Memory Database.SQL DBA
082. SQL Server 2016 Script to get information of Cached Functions with Total Execution Time
sys.dm_exec_function_stats which returns the aggregate performance statistics for cached functions, which is similar to sys.dm_exec_query_stats and it returns information about
081. Find Missing Indexes – SQL Server Script
Find Missing Indexes – SQL Server Script-1 Find Missing Indexes – SQL Server Script-2 Find Missing Indexes – SQL Server
078. Find Outdated Statistics – SQL Server Script
The purpose behind finding the outdated Statistics is, we should update those outdated indexes else our performance get hampered due
077. sys.column_store_row_groups to find information on Columnstore row groups – SQL Server 2014
sys.column_store_row_groups system view for finding the information on the Columnstore row groups, which introduced first in SQL Server 2014 Using
076. sys.dm_column_store_object_pool to find memory pool usage by Columnstore Indexes – SQL Server 2016
sys.dm_column_store_object_pool system view for finding the memory pool usage by different types of Columnstore Index objects, which introduced first in