T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I...
2017-01-10
438 reads
T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:
Announcing T-SQL Tuesday...
2017-01-10
491 reads
SQL Server Bugs & Enhancement Requests
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...
2017-01-10
639 reads
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests
This month’s T-SQL Tuesday is hosted by Brent Ozar and he’s asked everyone to find interesting bug or enhancement requests in Microsoft Connect related to SQL Server.
The Connect item doesn’t have...
2017-01-10
19 reads
Forcing Parallelism – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-01-09
561 reads
Getting Started Blogging–#SQLNewBlogger
It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think...
2017-01-09
737 reads
A Whole Day of PowerShell and SQL – Join Chrissy LeMaire & I at #sqlsatvienna
SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international...
2017-01-09
410 reads
Monday Coffee 2017-01-09
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...
2017-01-09
395 reads
SQL Server 2016 SP 1
By David Postlethwaite
SQL Server 2016 SP1 was released in November 2016 only five months after the initial release.
There have been...
2017-01-18 (first published: 2017-01-09)
2,601 reads
Should We Allow Paid Sponsor Presentations at PASS Summit?
For many years the PASS Summit program committee has enforced a bright line rule – no sponsor content in the educational...
2017-01-09
496 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