A Simple Overview of a SQL Query
Here are the 4 basic steps all queries go through: 1. Parsing: The query is examined by SQL Server to syntax errors, invalid…
Read MoreCategory: SQL Server
All things SQL Server
PASSMN User Group, Tuesday January 21st
Today we had a very informative presentation from Merrill Aldrich on SQL Server storage internals. Merrill demonstrated his SQL Server File Layout Viewer.…
Read More
Using WordPress with SQL Server
Here is a great step-by-step blog post on how to use SQL Server and WordPress: Installing WordPress on SQL Server Views –…
Read More
DBCC (Transact-SQL) Overview
SQL Server 2012 Posted from TechNet The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database…
Read More
A DBCC PAGE Example with Output
This post will demonstrate how to run the undocumented DBCC PAGE command to view the properties of a page. First we execute the…
Read More
NO RECOVERY vs RECOVER WITH STANDBY Log-shipping Modes
When you restore a transaction log using the NORECOVERY option, SQL Server does not need to analyze the transaction log and roll back…
Read More
The lifecycle of a SQL query
1. The command parser evaluates the query and generates a hash to see if the buffer pool has an execution plan already stored.…
Read More
The the most blocked queries
|
1 2 3 4 5 6 7 8 |
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 – 2132
Read More
Find resource currently involved in blocking
|
1 2 3 4 |
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 – 1867
Read More
Identifying blocking processes (lead blocker)
Posted on June 17, 2009 by Derek Dieter Finding the lead blocker in a chain of blocks is a difficult challenge when using…
Read More