The Query Optimizer uses statistics to create query plans to improve query performance and Statistics are one of the most
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
sys.dm_exec_sessions in SQL Server
sys.dm_exec_sessions will give information about each session connected to SQL Server. This DMV is similar to running sp_who2 stored procedure
Continue readingsys.dm_exec_connections in SQL Server
sys.dm_exec_connections : – sys.dm_exec_connections DMV shows all the connection to SQL Server and sys.dm_exec_connections is the most common DMV used
Continue readingWhat is Checkpoint in SQL Server ?
Checkpoint is an internal process that writes all the dirty pages (from the buffer cache to the physical disk) to
Continue readingPerformance Tuning :- How to identify blocking And Lead blocker in SQL Server
During normal processing in a database, it is blocked. Blocking is “by design” because your database is on ACID. In
Continue readingSQL Server – Cannot detach a suspect or recovery pending database
I tried to detach the database in one of our SQL servers, but received the following error:- Cannot detach
Continue readingSQL SERVER – Get Size of All Tables In Database
we are able to get a rough view of tables detail in a database like how many rows, total space,
Continue readingHow to Rename Column Name And Table Name In SQL Server
In this article we are going to show you,How to Rename Table Name and Column Name in SQL Server with
Continue readingSQL SERVER – Find Most Expensive Queries Using DMV
The following query returns the top 10 queries by total CPU time, to help you identify the most expensive queries
Continue readingsys.dm_exec_query_stats In SQL Server
Just as the text returned from the sql_handle is the text for the entire batch, the compiled plans that are
Continue reading