Azure Cosmos DB – Partition and Throughput
In my previous article Introduction to Azure Cosmos DB, I mentioned Partition and Throughput only briefly. Adopting a good partition scheme...
2018-08-17 (first published: 2018-08-05)
2,193 reads
Blog Posts
Format a Partial Script with #SQLPrompt
SQL Prompt is amazing and it’s my favorite tool. It’s actually what many people want first from Redgate because it...
2018-08-17
457 reads
Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'
Error: Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'Resolution:setTimeout the code that is setting the value. In my case,...
2018-08-17
191 reads
Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'
Error: Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'
Resolution:
setTimeout the...
2018-08-17
1,243 reads
Performance Basics: Indexed views
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
353 reads
Announcing new Guatemala SQL Server user group
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
731 reads
Is Your DR Plan Complete?
Kevin Hill (blog|twitter) posted a thought-provoking item on his blog last week about Disaster Recovery Plans. While I am in the 10% who perform DR tests for basic functionality...
2018-08-16
9 reads
Should You Use Index Hints?
Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...
2018-08-16 (first published: 2018-07-31)
3,942 reads
SQL Reserved vCores
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
348 reads
Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
28 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers