WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...
2015-07-17
7 reads
SQL Server: utilize partitioning to purge large tables
Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...
2015-07-17
3,600 reads
Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/
I'll be doing an update to...
2015-07-17
744 reads
Introduction To Query Store In SQL Server 2016 – Part 2
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,115 reads
How do different types of functions compare performance wise?
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,090 reads
SSC Editorial: Is the Golden Age of Information Technology Almost Over?
Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential...
2015-07-16
548 reads
Next oPASS Meeting is July 23, 2015 with David Crook
The next OPASS meeting is July 23, 2015, featuring David Crook from Microsoft doing a presentation on predicting home value...
2015-07-16
550 reads
SSMS 2015
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10...
2015-07-16
994 reads
Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy
Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the...
2015-07-16
1,109 reads
New Features of SQL Server 2016
The next version of SQL Server looks to add more and more features helpful in database design and administration as...
2015-07-16
987 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
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
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