Congrats to MSSQLTips on 10 Years!
MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the...
2016-06-06
562 reads
Elastic Query in Azure SQL Database and Views
The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...
2016-06-13 (first published: 2016-06-06)
2,163 reads
Painting with PowerShell SQL Server Administration
This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.
Here...
2016-06-06
100 reads
I need help with DBCC
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I...
2016-06-06
1,427 reads
Broadening Horizons: From DBA to Data Science #2 Math Fundamentals
In the previous article in this blog series I told you my plans of expending my horizons towards the Data...
2016-06-06
1,552 reads
ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like...
2016-06-06
16 reads
ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like...
2016-06-06
20 reads
SQL Server 2016 RTM – Is Anyone Still Waiting for the First Service Pack?
Well most of the SQL Server news last week focused around the launch of SQL Server 2016. SQL Server RTM...
2016-06-09 (first published: 2016-06-06)
4,212 reads
ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create...
2016-06-06
270 reads
ISJSON() restriction in T-SQL 2016
Have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with...
2016-06-06
432 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