In-memory tables in 60 seconds
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
305 reads
Why I Practice Presentations
I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want...
2016-10-13
852 reads
Too many indexes!
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
601 reads
My thoughts on Recertifying your MCSE through Microsoft Virtual Academy
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...
2016-10-13
790 reads
You don't need any Training? OK...I believe you.
This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...
2016-10-13
443 reads
Microsoft Certifications
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
538 reads
A quick note comparing ISNULL vs COALESCE
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,305 reads
MS Access – Store a Different Value than Displayed in a Combo Box
It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...
2016-10-13
473 reads
Check Database Server Workload - Batches/ Sec
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
3,146 reads
This Week In Data – Episode 8 (Mastering the Tech Interview)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-12
522 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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