Reading Extended Event File Session Data
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will frequently tell people to use is the file target....
2015-06-21
11 reads
Reading Extended Event File Session Data
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will...
2015-06-21
1,761 reads
A myth about view TIP #102
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer...
2015-06-20
539 reads
PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis
This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great...
2015-06-19
528 reads
008 – Wayne Sheffield – MCM - WaterOx Consulting
Reading Time: 2 minutesMeet the SQL Master! In WOxPod!, episode # 008 – “Wayne Sheffield...
The post 008 – Wayne Sheffield – MCM appeared first...
2015-06-19
570 reads
Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101
Let’s consider a scenario where the end user require a CSV file of all the records in a table then...
2015-06-18
1,310 reads
Thursday Morning SQL Break – June 15, 2015
It’s Thursday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-06-18
695 reads
Notes from the June 17, 2015 MagicPASS Meeting
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
374 reads
PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView
Join us today at noon central for Asgeir presenting for the Excel BI VC.
Thu, Jun 18 2015 12:00 Central Daylight...
2015-06-18
446 reads
Speaking at 24 Hours of PASS: Growing Our Community
24 Hours of PASS is just around the corner, and I’m happy to say that this time I’ll be speaking...
2015-06-18
568 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