Category: Tutorials
Programming Languages- c#, java, asp.net etc articles
088. SQL Server script to find dirty pages from Memory, when DBCC DROPCLEANBUFFERS fails
Dirty pages mean has not written to disk and Clean pages say the page is brought in to memory by
087. SQL Server Script to check the size of Query Plan Cache
As a DBA, when you are dealing with huge SQL OLTP system, you should monitor the size of Query Plan
085. Use sp_MSforeachtable to apply a T-SQL command to every table of selected Database in SQL Server
When we require executing same T-SQL command for all the tables, we can use this stored procedure. Many times we
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