Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the...
2018-09-10
33 reads
Blog Posts
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are...
2018-09-10
2,783 reads
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
656 reads
PASS FY2019 Budget Notes Updated
PASS has updated the notes supporting the FY 2019 budget to answer the questions I raised in my earlier post....
2018-09-10
283 reads
Redgate University is Growing
There isn’t a degree to be gained, but you can get a lot of information about Redgate products at Redgate...
2018-09-10
230 reads
Relational databases aren’t the problem
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is...
2018-09-10 (first published: 2018-08-22)
3,158 reads
Remember the Default Window
I ran across a question recently from a user about why they had strange results from a windowing query. This...
2018-09-10 (first published: 2018-08-23)
2,683 reads
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run...
2018-09-10
74 reads
PASS Summit 2018 – Scheduled Released
The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which...
2018-09-08
242 reads
PASS Summit 2018 – Scheduled Released
The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which were released a couple of months ago.
Wednesday thru Friday...
2018-09-08
50 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