Gethyn Ellis:My SQL Server You Tube Channel
Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning...
2017-04-10
321 reads
Monday Coffee 2017-04-10
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
178 reads
Monday Coffee 2017-04-10
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
303 reads
Missing index with create statements
Missing index :- Scripts will help you to get all the missing index and prepare script for new index.
/*
Description:- This Query...
2017-04-10
680 reads
Step by Step Configuring a Dedicated Network for Availability Group
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage of using a separate network for replication is reduced...
2017-04-10
19 reads
Step by Step Configuring a Dedicated Network for Availability Group
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage...
2017-04-10
896 reads
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2017-04-09
12 reads
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check...
2017-04-09
540 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of...
2017-04-08
21 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of...
2017-04-08
43 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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