4 Things You’ll Need Before Installing a Failover Cluster Instance
Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and...
2015-05-25
502 reads
Changing NULL to NOT NULL – Dealing with Data
I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple...
2015-05-25
675 reads
Database Administration via CrowdSourcing
According to Wikipedia:
Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group...
2015-05-25
334 reads
Database Administration via CrowdSourcing
According to Wikipedia:
Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group...
2015-05-25
686 reads
2015-05-25
558 reads
Presenting To The Orlando .Net Users Group on June 11, 2015
I’ll be returning to ONETUG just less than a year from my last presentation, delivering technical content and evangelizing for...
2015-05-25
318 reads
Last Cumulative Update – 16 for SQL Server 2012 Service Pack 1 Is Now Available !
The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2015-05-25
705 reads
Cumulative Update – 6 for SQL Server 2012 Service Pack 2 Is Now Available !
The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2015-05-25
980 reads
SQL Server 2014 Service Pack 1 (SP1) Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for...
2015-05-25
864 reads
CDO Summit Toronto June 4th
I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th. My session is on...
2015-05-24
446 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