Recap of our SQL Saturday #225 in Kosovo, Prishtina
SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan...
2013-05-27
1,235 reads
How to Size the SQL Server Memory & Why is it important?
The following blog post has 2 objectives.
1) How to size the memory correctly ( or atleast being close to correctly )
2)...
2013-05-27
2,931 reads
Security Questions: Difference between sysadmin and CONTROL SERVER Permission
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-05-27
865 reads
Looking for Buried Treasure in the Transaction Log
Lately, I’ve been finding more and more reasons to look in the transaction log for investigative purposes. Questions come up...
2013-05-27
1,210 reads
Last Weeks Top “Reading” Links #34
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-27
541 reads
The 2013 SQL in the City Tour
Once again, Red Gate is planning on a tour of the US for the SQL in the City events. Last...
2013-05-27
860 reads
Bulk Insert Task SSIS – Path Specified Cannot be Found or File Does Not Exist
When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist...
2013-05-27
786 reads
Use Lookups the right Way
SSIS Lookup tasks are all too easy to abuse as they are easy to setup and not really think about...
2013-05-27
325 reads
Temporary Post Used For Theme Detection (6a375569-f9c1-4835-a7fb-fa1ba0b240e4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2013-05-25
781 reads
Have you configured Database Mail to utilize multiple SMTP Accounts ?
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the...
2013-06-03 (first published: 2013-05-24)
2,305 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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