Applied SQL: sys.objects
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,383 reads
Blog Posts
Applied SQL: You Have Homework
I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do...
2011-08-17
585 reads
Microsoft SharePoint Online
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
936 reads
PASSMN Presentation – The Creepy DBA
Last night I spoke at the PASSMN August user group meeting. The topic was The Creepy DBA and how you...
2011-08-17
671 reads
RAID server configuration and disk amounts
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge.
Typical questions from...
2011-08-17
1,106 reads
SQL MCM Training – Day 9
Today Jonathan was talking the whole day about Consolidation and Virtualization. There
were again a lot of new concepts, and new...
2011-08-17
963 reads
TSQL Sudoku
I am a big Sudoku fan. Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android...
2011-08-17
17 reads
TSQL Sudoku
I am a big Sudoku fan. Typically if I need a break, I will break out a Sudoku puzzle from...
2011-08-17
1,045 reads
Writing Your Resume
There’s a lot of info out there about putting together a resume, and I probably can’t add a lot, but...
2011-08-17
792 reads
Announcing the upcoming Colorado GiveCamp
What is a GiveCamp?
GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...
2011-08-16
523 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