freedom
I was thinking back fondly of my Dad - who passed away during Hurricane Sandy - this past Father's Day. Of the...
2013-07-03
565 reads
Install Windows Server 2012 on VMWare Workstation 8
Sometimes we try an do things that just shouldn’t work. Maybe they aren’t supported or there technology isn’t designed for...
2013-07-03
1,229 reads
SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we really need to do manual statistics maintenance to keep...
2013-07-03
70 reads
SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we...
2013-07-09 (first published: 2013-07-02)
4,947 reads
Notes from the 2013 American Association of Woodturners Symposium
This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick...
2013-07-02
784 reads
trace flag for backup and restore operation
1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO
3605 means output the message to errorlog. you can use 3604...
2013-07-02
4,657 reads
SQL Server Pro Article: Custom Programming to Enhance SSRS Reports
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...
2013-07-02
919 reads
SQL in the City London 2013
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
728 reads
T-SQL Tuesday #44 The Second Chance
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2013-07-02
2,299 reads
SQL Server Data Tools (SSDT) – June 2013 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version:...
2013-07-02
2,121 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