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)
15,479 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,740 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.
2015-04-28 (first published: 2010-07-29)
46,078 reads
Partitioned Views
A look at Partitioned Views, their advantages, disadvantages backed up by examples and statistics.
2013-12-05
4,608 reads
SSIS Distributed Transactions
This article shows the steps to set-up distributed transactions for SSIS.
2013-11-07
10,799 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
9,606 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,783 reads
2010-12-16
11,891 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
12,066 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers