Querying Deadlocks From System_Health XEvent

• by SteveHood79

• Simple SQL Server

It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is...

2016-01-27 (first published: 2016-01-25)

2,888 reads

Tim Ford’s Entry-Level Content Challenge

• by SteveHood79

• Simple SQL Server

All bloggers started as beginners.  We picked things up, learned them, and got to the point where we wanted to...

2016-01-26

563 reads

Tim Ford’s Entry-Level Content Challenge

• by SteveHood79

• Simple SQL Server

All bloggers started as beginners.  We picked things up, learned them, and got to the point where we wanted to start sharing our knowledge.  The problem is that most...

2016-01-26

Querying Deadlocks From System_Health XEvent

• by SteveHood79

• Simple SQL Server

It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is already capturing this information by default. This script will,...

2016-01-25

8 reads

Shrinking Database Data Files

• by SteveHood79

• Simple SQL Server

Normal DBAs will sum up shrinking a database data file in one word: NO!
I’ll talk to you about this subject because...

2016-01-19

1,681 reads

Shrinking Database Data Files

• by SteveHood79

• Simple SQL Server

Normal DBAs will sum up shrinking a database data file in one word: NO! I’ll talk to you about this subject because I’m not normal.  Still, my goal is that...

2016-01-19

18 reads

SQL Saturday Cleveland #SQLSat473

• by SteveHood79

• Simple SQL Server

On February 6, 2016, Cleveland is hosting a free training event for SQL Server.  This has a lot of the...

2016-01-11

521 reads

SQL Saturday Cleveland #SQLSat473

• by SteveHood79

• Simple SQL Server

On February 6, 2016, Cleveland is hosting a free training event for SQL Server.  This has a lot of the great stuff from the big, paid events, and skips...

2016-01-11

TempDB memory leak?

• by SteveHood79

• Simple SQL Server

I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server,...

2016-01-08 (first published: 2016-01-05)

3,311 reads

Query the Buffer Pool

• by SteveHood79

• Simple SQL Server

DBAs are known for asking for more memory, but often can’t say what’s in memory.  While I agree that many...

2016-01-07 (first published: 2016-01-04)

2,556 reads