Our space judges are checking over the DBA in Space entries ready to reveal the finalists on December 6th. Meanwhile, we've revealed the answers, so why not take a look?
2011-11-30 (first published: 2011-11-25)
4,446 reads
Red Gate is doing some research into Visual Studio add-ins for SQL development. If you can spare a moment to complete a short survey, or are interested in being part of the early access program (linked from the end of the survey), please click here.
2011-11-30
2,845 reads
Join this webinar on Tuesday, Nov 29, 2011 to see how SQL Monitor and SQL Source Control can help you solve problems in your environment.
2011-11-29 (first published: 2011-11-21)
1,205 reads
2011-11-29 (first published: 2010-03-31)
10,022 reads
The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.
2011-11-29
4,572 reads
The loss of a company's data is often enough to put the company out of business; and yet backup errors are generally avoidable with the application of common sense rather than deep technical knowledge. Grant digs into memories of his long experience of giving forum advice, to come up with the most easily preventable backup errors.
2011-11-29
2,910 reads
This challenge invites you to identify the longest sequence of alphabets from a string.
2011-11-28
996 reads
How to incorporate data mining directly into the Data Flow of SQL Server 2008 R2 Integration Services-based packages.
2011-11-28
2,226 reads
This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.
2011-11-25
15,860 reads
SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
2011-11-25
4,497 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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