Query to Find "Update" Dependencies on a Table or View (SQL Server 2012)
The built-in dependency finder in SQL Server Management Studio does not provide the ability to distinguish between dependencies that are...
2013-07-23
2,867 reads
Security Questions: Granting Access with Jobs
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-22
602 reads
Last Weeks Top “Reading” Links #42
Number 42 of this weekly previous week round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day...
2013-07-22
1,079 reads
70-457 Reviewer #05, Configuring SQL Server 2012 Components
The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration...
2013-07-22
578 reads
Upscale Bowling
I don’t bowl often, maybe once a year at best. It’s a fun way to spend a couple hours – I...
2013-07-22
710 reads
SQL Server – Get values as DATETIME from sysjobhistory
This is a follow-up post on SQL Server – Check SQL Agent Job History using T-SQL.
SQL Server Agent stores SQL jobs...
2013-07-22
740 reads
Creating a Rolling Date Range Named set in MDX
One Client I was working with wanted a named set that would give them the last 5 years. Of course...
2013-07-22
1,014 reads
Generic Dynamic SQL Stored Procedure
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,642 reads
SQL Saturday Orlando – My First Presentation!!!
I’ve submitted presentations before to CodeCamp and SQL Saturdays before, but have never been selected to present due to terrible...
2013-07-21
296 reads
SQL 2012 SSIS Catalog Permissions
With the introduction of the SQL 2012 SSIS Catalog there has been the question of what permissions are available and...
2013-07-20
1,113 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