SQLNewBlogger, Week 3
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
222 reads
SQLNewBlogger, Week 3
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
329 reads
Duplicate MySQL Table Using phpMyAdmin
There many reasons for creating copies of existing relational database tables. Sometimes you create duplicate tables for the purposes of...
2015-11-14
3,586 reads
Thankful in November
I’m taking a short break from technical talk today to spend a few minutes thinking about life. My wife started...
2015-11-13
554 reads
How to identify the source of page splits in a database
Page splits can slow down your queries and increase the amount of I/O needed to retrieve your data.
So, how do...
2015-11-13
2,194 reads
Add Dependencies to a SQL Server Resource in Windows 2003
Read My Article "Here"
For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com
2015-11-13
100 reads
How do we insert the results of the stored procedure in a table?
This question has two crinkle answers –· When the table is already created.
· When the table is to be created run...
2015-11-13
150 reads
Git Pull in SQL Source Control
I wrote recently on Git Push in SQL Source Control (SOC), and now wanted to add the other side of...
2015-11-12
1,338 reads
A Data Age proclamation
Twice in two days now, I’ve gotten in discussions with people about the state of data usage…the idea that we have...
2015-11-12
703 reads
Community Involvement–Why Wait?
Everyone has a story; some stories are similar while some stories are vastly different. People always make the statement that...
2015-11-12
627 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