Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Jason Brimhall profile

   Items 1 to 7 of 7   

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2016/05/13 (first published: 2014/03/04) | Source: | Category: execution plans
Rating: |  Discuss |   Briefcase | 13,562 reads

Exporting Execution Plans - SQL Spackle

A short SQL Spackle article to fill in your knowledge of SQL Server. In this one, Jason Brimhall shows how to export execution plans when you ask for query tuning help.  Read more...
By Jason Brimhall 2013/10/29 | Source: | Category: execution plans
Rating: |  Discuss |   Briefcase | 4,219 reads

Using SSIS to Maintain the File System

Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.  Read more...
Rating: |  Discuss |   Briefcase | 6,679 reads

Toys V. Tools

What's a toy and what's a tool? This Friday, a guest editorial from Jason Brimhall asks what in technology might be considered a toy or a tool, or perhaps, both.  Read more...
By Jason Brimhall 2011/02/04 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 202 reads

Join Operations – Nested Loops

This is part I of III in a series on the physical join operators in SQL Server.  Read more...
By Jason Brimhall 2013/02/01 (first published: 2011/01/04) | Source: | Category: join
Rating: |  Discuss |   Briefcase | 25,138 reads

What, When, Where, How, Who2

Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.  Read more...
By Jason Brimhall 2010/06/14 | Source: | Category: sp_who2
Rating: |  Discuss |   Briefcase | 11,118 reads

Log Growing Pains

Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.  Read more...
By Jason Brimhall 2010/03/11 | Source: | Category: log growth
Rating: |  Discuss |   Briefcase | 14,822 reads
   Items 1 to 7 of 7