What is the Max Degree of Parallelism setting for SQL Server?
Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server. What exactly does...
2019-01-07 (first published: 2018-12-21)
2,784 reads
Blog Posts
Hello Cristian,
Hello Cristian,
Thank you for sharing the link and your contribution. The idea behind the article is to be able to upload any file while the server is been provisioned....
2019-01-06
21 reads
Last Week Reading (2019-01-06)
Good morning chaps! Bunch of news from data’s world freshly served. Press Introduction to Testing Your PowerShell Code with Pester...
2019-01-06
182 reads
When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
66 reads
One tip for presenting: have a conversation
I like public speaking, but I haven’t always liked it. It started when I read Dale Carnegie’s book on public...
2019-01-05
45 reads
Short Circuiting Your Session
It isn't very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule - Extended...
2019-01-05
22 reads
Automatic Tuning Monitoring and Diagnostics
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...
2019-01-04
34 reads
Fun Time Friday: New Year! Drones, Autism and SQL Server 2008
Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New Year to our friends, customers and clients.
SQL Server 2008...
2019-01-04
29 reads
Fun Time Friday: New Year! Drones, Autism and SQL Server 2008
Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New...
2019-01-04
225 reads
How to upload a vagrant file while provision a server
How to upload a vagrant file while provisioning a server
I was recently introduced to vagrant and i found it very interesting. I picked up a task that which is creating...
2019-01-04
20 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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