Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This...
2015-11-24
31 reads
Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...
2015-11-24
56 reads
Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...
2015-11-24
46 reads
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...
2015-11-23
14 reads
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 7.
The partitioning includes several major...
2015-11-30 (first published: 2015-11-23)
1,510 reads
Using multiple log files
The transaction log is made up of one or more files that are used sequentially. So in other words if...
2015-11-27 (first published: 2015-11-23)
1,560 reads
Cumulative update package 9 for SQL Server 2012 SP2
Microsoft just announced Cumulative update package 9 for SQL Server 2012 SP2
Microsoft reference: [Click Here]
For more updates:
Subscribe for Blog posts [Click Here]
Follow...
2015-11-23
143 reads
Steps to install SQL Server CTP 3 on Windows Azure
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...
2015-11-23
504 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-27 (first published: 2015-11-22)
1,729 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost...
2015-11-22
10 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