How to Edit Read-Only Non-clustered Columnstore Data
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,132 reads
Everyday SQL
Columnstore Table Analyzer
As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part...
2014-07-08
773 reads
Columnstore Memory Grant Issue
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...
2014-06-03
2,212 reads
Comparison of Columnstore Compression
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,854 reads
What is a Non-Clustered Columnstore Index?
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,629 reads
The system_health Extended Event Session
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)
4,078 reads
How Long is that SQL Command Going to Take?
Have you ever needed to restore a large database while someone is standing over your shoulder asking “How long is...
2014-03-04
3,253 reads
My Experience Aboard SQL Cruise 2014
Where do I begin? First let me say, WOW what an experience!
How it All Began
When I first heard about SQL...
2014-02-11
1,381 reads
Collecting Historical IO File Statistics
In a previous post, Collecting Historical Wait Statistics, I discussed how you can easily collect historical wait stats by using...
2013-12-17
1,483 reads
Collecting Historical Wait Statistics
As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...
2013-12-16 (first published: 2013-12-11)
2,523 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 [email protected] 8 [email protected]If I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers