Tag: SQL Internals

Indexed View(s) An indexed view is a view where the result set from the query (the view definition) becomes materialized in

January 28, 2016

Disk Space in SQL Server One of the frequently required job functions of the database administrator is to track disk

January 21, 2016

Across many professions and industries there is often a need to have some sort of device that “audits” everything that

January 12, 2016

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying

September 1, 2015

Everything can be fixed with a query hint (*cough* directive), right? If a certain process is consistently causing deadlocks, a simple

July 21, 2015

You may recall an article I had written a couple months back describing how to use Extended Events to perform

April 22, 2015

What do you do when a developer comes to you and asks, “Where did the database go? The database was

April 7, 2015

A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka

March 11, 2015

Get Started