Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Brian Ellul

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

Column Store vs Row Store Indexes

How does a column store index compare to a (traditional)row store index with regards to performance  Read more...
By Brian Ellul 2015/05/14 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 6,319 reads

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.  Read more...
By Brian Ellul 2015/05/07 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 10,423 reads

Partitioned Views

A look at Partitioned Views, their advantages, disadvantages backed up by examples and statistics.  Read more...
By Brian Ellul 2013/12/05 | Source: SQLServerCentral.com | Category: partitioned views
Rating: |  Discuss |   Briefcase | 2,946 reads

Improving SSIS Update Performance

This article includes an examination of how I improved update performance. We examine four methods of loading data into a data warehouse.  Read more...
Rating: |  Discuss |   Briefcase | 6,135 reads

SSIS Distributed Transactions

This article shows the steps to set-up distributed transactions for SSIS.  Read more...
By Brian Ellul 2013/11/07 | Source: SQLServerCentral.com | Category: dtc
Rating: |  Discuss |   Briefcase | 4,230 reads

The FILL FACTOR

Will the FILLFACTOR Index option help to boost my database performance?  Read more...
By Brian Ellul 2010/12/16 | Source: SQLServerCentral.com | Category: fill factor
Rating: |  Discuss |   Briefcase | 10,925 reads

Ways to minimize sort operations

In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.  Read more...
By Brian Ellul 2010/09/15 | Source: SQLServerCentral.com | Category: sort operator
Rating: |  Discuss |   Briefcase | 10,742 reads

Tips to Optimize Your SQL Statements - Part 1

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.  Read more...
By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 44,098 reads

Sub query expressions vs. Joins.

Do sub query expressions introduce a performance penalty on retrieving large data sets?  Read more...
By Brian Ellul 2012/01/20 (first published: 2010/07/22) | Source: SQLServerCentral.com | Category: table spool operator
Rating: |  Discuss |   Briefcase | 28,595 reads
   Items 1 to 9 of 9