Lincoln Bovee’ – Page 11

DBCC (Transact-SQL) Overview

Posted on 01/22/201401/21/2019 by Lincoln Bovee'

SQL Server 2012 Posted from TechNet The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database…

A DBCC PAGE Example with Output

Posted on 01/21/201403/27/2014 by Lincoln Bovee'

This post will demonstrate how to run the undocumented DBCC PAGE command to view the properties of a page. First we execute the…

MySQL Reference

Posted on 01/20/201401/20/2014 by Lincoln Bovee'

Views – 1470

NO RECOVERY vs RECOVER WITH STANDBY Log-shipping Modes

Posted on 01/11/201401/21/2019 by Lincoln Bovee'

When you restore a transaction log using the NORECOVERY option, SQL Server does not need to analyze the transaction log and roll back…

The lifecycle of a SQL query

Posted on 01/10/201401/21/2019 by Lincoln Bovee'

1. The command parser evaluates the query and generates a hash to see if the buffer pool has an execution plan already stored.…

The the most blocked queries

Posted on 01/10/201402/07/2014 by Lincoln Bovee'

SELECT 
    OBJECT_NAME(objectid) 
    ,BlockTime = total_elapsed_time - total_worker_time
    ,execution_count 
    ,total_logical_reads 
FROM sys.dm_exec_query_stats qs
CROSS apply sys.dm_exec_sql_text(qs.sql_handle) 
ORDER BY total_elapsed_time - total_worker_time DESC

SELECT

OBJECT_NAME(objectid)

,BlockTime = total_elapsed_time - total_worker_time

,execution_count

,total_logical_reads

FROM sys.dm_exec_query_stats qs

CROSS apply sys.dm_exec_sql_text(qs.sql_handle)

ORDER BY total_elapsed_time - total_worker_time DESC

Views – 1870

Find resource currently involved in blocking

Posted on 01/10/201402/07/2014 by Lincoln Bovee'

SELECT DISTINCT objname = object_name(p.object_id)
FROM sys.partitions p
JOIN sys.dm_tran_locks t1
ON p.hobt_id = t1.resource_associated_entity_id

SELECT DISTINCT objname = object_name(p.object_id)

FROM sys.partitions p

JOIN sys.dm_tran_locks t1

ON p.hobt_id = t1.resource_associated_entity_id

Views – 1637

EXEC sys.sp_check_log_shipping_monitor_alert 

SELECT secondary_database, last_restored_date
  FROM msdb.dbo.log_shipping_secondary_databases

EXEC sys.sp_check_log_shipping_monitor_alert

SELECT secondary_database, last_restored_date

FROM msdb.dbo.log_shipping_secondary_databases

First check the last file copied and restored to the secondary. Run the following queries on the secondary node. The following query…

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, Linux and PostgreSQL etc…

Author: Lincoln Bovee'