SQL Server – Hide an Instance of SQL Server
You can browse available SQL Instances on network by choosing "<Browse for More..>" from Server Name drop-down list in "Connect...
2011-08-23
2,129 reads
Computed Columns and CASE
I wrote about computed columns recently, but I didn’t realize that a logical expression could be used here, such as...
2011-08-23
29,017 reads
Help with testing Denali, SQL Server 11
Earlier this week, Dan Jones, one of the Microsoft employees on the SQL Server team, wrote a blog post asking...
2011-08-23
1,025 reads
SQLRelay UK
With the Olympics coming to the UK next year what better way to get into the spirit of things than...
2011-08-23
604 reads
Running totals in “Denali” CTP3
One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause....
2011-08-23
803 reads
TSQL Sudoku II
Learn how to solve Sudoku puzzles quickly with a TSQL Script.
Related Posts:
Puzzles and Daily Trivia May 14, 2019
Summiting that Technical Challenge Part II July 6, 2018
Passion, Challenges,...
2011-08-23
18 reads
TSQL Sudoku II
As luck would have it, today I came across this TSQL Challenge. It just so happens that I had already...
2011-08-23
1,089 reads
Defining Your Culture
Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...
2011-08-23
651 reads
Disk IO performance and SQLIO
Performance testing a new disk subsystem from a SQL Server perspective is one of the fun aspects of DBA work....
2011-08-23
3,450 reads
Autogrow bug – fixed with Denali
Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...
2011-08-23
1,879 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