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,120 reads
Patrick
- Twitter: @patrickkeisler
- Website: https://www.patrickkeisler.com
- LinkedIn: https://www.linkedin.com/in/patrickkeisler/
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
762 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,195 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,842 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,588 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,053 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,238 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,373 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,472 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,508 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers