SQL PASS Summit Final Day (Sessions)
Here is a summary of the final day of sessions I attended at PASS. Vertipaq vs OLAP – Change Your Data...
2011-10-16
496 reads
Here is a summary of the final day of sessions I attended at PASS. Vertipaq vs OLAP – Change Your Data...
2011-10-16
496 reads
Here is the summary of the session I attended while at my 4th day at the Summit. (Technically, this is...
2011-10-16
428 reads
Got to David DeWitt’s Keynote a bit late so this will not cover as much as normal. (For the record,...
2011-10-14
494 reads
After a info filled keynote, on to the rest of the day. I decided to attend the Bare Metal Instructor...
2011-10-13
479 reads
Bill Graziano kicked off the event today with the notice of the official “Kilt Day” at the Summit. He also...
2011-10-13
434 reads
From the PASS president, Rushabh Mehta. PASS has facilitated 430,000 hours of training and expansion into the global community. These...
2011-10-12
470 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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