Everyday SQL

SQL Cruise Caribbean 2015 Recap

• by patrickkeisler

• Everyday SQL

UPDATED: Don't just take my word. Read the feedback from others.
SQL Cruise Caribbean 2015: More Than A Cruise With Classes....

2015-02-24

1,103 reads

Get Out There and Challenge Yourself

• by patrickkeisler

• Everyday SQL

It’s been almost five months since I posted my last article, and so much has changed since then. I have...

2015-02-11 (first published: 2015-02-03)

6,562 reads

PowerPoint Slides Available for Download

• by patrickkeisler

• Everyday SQL

I promised that I would post the slide decks for my presentations, and now I have finally followed through on...

2015-02-02

675 reads

Monitor the Number of Deleted Rows in a Clustered Columnstore Index

• by patrickkeisler

• Everyday SQL

In some of my previous posts, I have talked about how to create Columnstore indexes. Now I’d like to discuss...

2014-08-21

1,716 reads

How to Edit Read-Only Non-clustered Columnstore Data

• by patrickkeisler

• Everyday SQL

As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...

2014-08-06 (first published: 2014-07-29)

8,089 reads

Columnstore Table Analyzer

• by patrickkeisler

• Everyday SQL

As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part...

2014-07-08

751 reads

Columnstore Memory Grant Issue

• by patrickkeisler

• Everyday SQL

In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...

2014-06-03

1,918 reads

Comparison of Columnstore Compression

• by patrickkeisler

• Everyday SQL

SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same...

2014-05-20

1,768 reads

What is a Non-Clustered Columnstore Index?

• by patrickkeisler

• Everyday SQL

First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...

2014-04-29

4,956 reads

The system_health Extended Event Session

• by patrickkeisler

• Everyday SQL

When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...

2014-04-21 (first published: 2014-04-08)

3,921 reads