Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations is different in the case of Columnstore.
Before we describe the differences, let’s remind ourselves how data manipulation works in Columnstore:
Inserts go into an object called Delta Store,… Read more
Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when the table will stop being blocked and when their precious queries will run fast. What can you tell them?
SQL Server allows tracking the progress of index build and rebuilds.… Read more
SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows out at the same time. For instance, the Nested Loops iterator gets rows from its outer input and sends the matching rows on to the next iterator without having… Read more
Were you ever in a situation where you ran a query, it ran for a long time and you didn’t know what it was doing? Sure you were..
What if you had a visual indication of where things are stuck in your execution plan, while the query is running?
A… Read more
When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you understand a few things in order for your applications to work properly after a failover. For the sake of our discussion, let’s assume we have a multi-subnet… Read more
Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.
A few days ago, all of the session recordings were uploaded to the SQLBits site.
About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast about SQL Server. He was pretty surprised, but we started working on it.
If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great things about SQL Server is the fact that it’s super easy to start working with it: You download the installation (or connect to the Azure portal and get a VM),… Read more
On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to everyone who attended my session.
The scripts and presentation can be downloaded here.
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s comfortable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined… Read more
About two months ago, after 2.5 years, I left Microsoft.
Microsoft is an amazing place to work for. It’s conformable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined perfectly to make… Read more
Over the time as a SQL Server professional, I’ve come to an understanding about 3 important interview-related factors you’ll need in order to find a job you’ll love (Of… Read more
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small Changes Can Make a World of Difference”, talking about a bunch of “small” features that were introduced in SQL Server 2012 and 2014,… Read more
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
The issue is that using… Read more
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day a developer wanted my help in troubleshooting a MERGE that caused an ACCESS VIOLATION error and a stack dump generation. That… Read more
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance tuning a lot, and even more, I love challenges. But sometimes taking a query from the “good enough zone” down to “super-performance zone” will take a lot… Read more
2013 was an amazing and intense year. To recap it, I thought about sharing some of the things I learned:
- I love Parallelism. Once you get used to look for parallelism options in your queries, and…
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
It’s Friday, Friday
It… Read more
While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter) to the Israeli SQL Server Radio, the Podcast I co-host with Guy Glantser (blog | twitter Read more
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got there on Tuesday morning, which left me a whole day to get around the city. I traveled in the city center, ate a delicious pancake, drank a lot of… Read more