Indexed Views – Performance Panacea or Plight
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
Tag: SQL Internals
Disk Space and SQL Server
Disk Space in SQL Server One of the frequently required job functions of the database administrator is to track disk
January 21, 2016
SQL Black Box Recorder
Across many professions and industries there is often a need to have some sort of device that “audits” everything that
January 12, 2016
What Sessions are Deployed?
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying
September 1, 2015
An Experiment with Deadlocks
Everything can be fixed with a query hint (*cough* directive), right? If a certain process is consistently causing deadlocks, a simple
July 21, 2015
Upgrading From SQL Server Profiler
You may recall an article I had written a couple months back describing how to use Extended Events to perform
April 22, 2015
Where did the Database Go?
What do you do when a developer comes to you and asks, “Where did the database go? The database was
April 7, 2015
How To: XEvents as Profiler
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka
March 11, 2015