SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
234 reads
SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
735 reads
SQL Server Service Broker – Internal Activation
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database...
2016-05-24
212 reads
SQL Server Service Broker – Internal Activation
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-05-24
706 reads
Reblog: Unexpected result with the File System Task
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default...
2016-06-03 (first published: 2016-05-24)
1,184 reads
The new SQL Server Management Studio 2016
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....
2016-05-24
14 reads
The new SQL Server Management Studio 2016
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....
2016-05-24
9 reads
Database Restore Fails with Msg 3154
Have you ever tried to restore over an existing database only to receive the following error message?
Msg 3154, Level 16,...
2016-05-24
866 reads
The new SQL Server Management Studio 2016
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation...
2016-05-24
233 reads
Live execution plans
SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...
2016-05-24
7 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