Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
574 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
6,042 reads
Last Restore of a Database – Back to Basics
In this article I explore the basics around how to determine when a database was last restored.
Related Posts:
Changing Default Logs Directory - Back to Basics January 4, 2018
SQL...
2016-12-20
50 reads
Last Restore of a Database – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
676 reads
Replay your workload through the Query Store Replay script!
One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk...
2016-12-19
1,369 reads
New whitepaper with ScaleArc
I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft...
2016-12-19
354 reads
PowerShell : Monitoring and Notification – Disk Space Alerts
“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”
Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...
2016-12-19
1,032 reads
PASS Board: Year-End Wrap-Up
This month concludes my second full year on the PASS Board of Directors and my first full year on the...
2016-12-19
418 reads
Announcing Tuga IT 2017
Its the right time & the right moment of the year to announce the 2nd edition of the ultimate portuguese IT...
2016-12-19
300 reads
:OUT :OUT darn results!
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...
2016-12-19
461 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