Dirty pages mean has not written to disk and Clean pages say the page is brought in to memory by

As a DBA, when you are dealing with huge SQL OLTP system, you should monitor the size of Query Plan

When we require executing same T-SQL command for all the tables, we can use this stored procedure. Many times we

In the below script, you can add a filter of your database and table for getting the number of Forwarding

SQL Server 2014 introduced the concept of In-Memory Database which provides the best combination of RDBMS + In-Memory Database.SQL DBA

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

Find Missing Indexes – SQL Server Script-1 Find Missing Indexes – SQL Server Script-2 Find Missing Indexes – SQL Server

The purpose behind finding the outdated Statistics is, we should update those outdated indexes else our performance get hampered due

sys.column_store_row_groups system view for finding the information on the Columnstore row groups, which introduced first in SQL Server 2014 Using