Column Store vs Row Store Indexes
How does a column store index compare to a (traditional)row store index with regards to performance
2016-12-30 (first published: 2015-05-14)
12,352 reads
Brian Ellul
- Interests: Obviously SQL Server :) Renewable Energy Solutions.
Tips to Optimize Your SQL Statements - Part 2
Read more tips to optimize SQL statements, specifically on a Data warehouse.
2015-05-07
13,571 reads
Partitioned Views
A look at Partitioned Views, their advantages, disadvantages backed up by examples and statistics.
2013-12-05
4,173 reads
SSIS Distributed Transactions
This article shows the steps to set-up distributed transactions for SSIS.
2013-11-07
7,111 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.
2013-10-31
8,170 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.
2012-02-10 (first published: 2010-07-29)
45,453 reads
Sub query expressions vs. Joins.
Do sub query expressions introduce a performance penalty on retrieving large data sets?
2012-01-20 (first published: 2010-07-22)
28,680 reads
2010-12-16
11,371 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.
2010-09-15
10,844 reads
Blogs
Data Saturday #8–Southwest US
By Angela-Henry
I am very excited to announce that I will be speaking for Data Saturday...
Data Weekender v3.1
By Angela-Henry
I am super excited about this new version of Data Weekender, coming up on...
Thanks Kathi and Mala
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
Search all Tables in DB for a String but using Postgres - What is the difference
Hi Forum, I want to search a Database for a String value and I...
SQL 2016 - Need help with complex calculations based on paycodes - New Changes
Hello Friends, Posting this for help as the client made more requirement changes. I...
Ask SSC