SQL Server – DROP IF EXISTS in SQL Server 2016
Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets...
2015-11-27
1,142 reads
Value can not be null Parameter Name:store TFS WorkItem Store Error
Error HRESULT E_FAIL has been returned from a call to a COM component.
Description:
System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned...
2015-11-26
1,417 reads
UK Contractors – As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks...
2015-11-26
18 reads
UK Contractors - As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn...
2015-11-26
450 reads
UK Contractors - As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn...
2015-11-26
913 reads
Covering Indexes
Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...
2015-12-03 (first published: 2015-11-26)
3,308 reads
Steps to create SQL database at Azure
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...
2015-11-26
878 reads
Complete DAX Function Reference
The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details for...
2015-11-26
1,036 reads
Convert select statements in scripts into Inline-TVF's automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
In-line TVF's are awesome, they are a great way to reuse T-SQL code without the...
2015-11-25
900 reads
Convert select statements in scripts into Inline-TVFs automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror...
2015-11-25
14 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