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)
10,373 reads
Brian Ellul
Tips to Optimize Your SQL Statements - Part 2
Read more tips to optimize SQL statements, specifically on a Data warehouse.
2015-05-07
13,469 reads
Partitioned Views
A look at Partitioned Views, their advantages, disadvantages backed up by examples and statistics.
2013-12-05
3,573 reads
SSIS Distributed Transactions
This article shows the steps to set-up distributed transactions for SSIS.
2013-11-07
5,264 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
6,776 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,114 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,649 reads
2010-12-16
11,098 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,804 reads
Blogs
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
What's New in SQL 2019? at BRSSUG
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Forums
Using crypt_gen_random to generate unique Serial Numbers
Trying to generate unique serial numbers with alphanumerics (A-Z,a-z,0-9) and no special characters.Used below...
OPENQUERY is not inserting identical rows
Hi, Thanks in advance for any help. I am trying to insert into a...
Azure file copy creating a directory to hold the renamed file
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
Ask SSC