2011-11-24
44 reads
Articles
2011-11-24 (first published: 2010-03-24)
10,610 reads
Total Database Information At Your Fingertips Part - II
This article will help to get some basic information from your databases that may help you in different situations.
2011-11-24
5,589 reads
SQL Server Functions: The Basics
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
2011-11-24
4,190 reads
SQL Server AlwaysOn - Part 2 - Availability Groups Setup
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-23
2,321 reads
Survey: Do You Monitor Your Databases?
We're looking to find out more about whether you monitor your databases, and how you do it. If you can spare a moment to complete a short survey, please click here.
2011-11-23
1,962 reads
Dealing with Incomplete Data - A T-SQL Puzzle 1
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
2011-11-22
4,313 reads
2011-11-22 (first published: 2010-03-17)
10,505 reads
Finding the Source of Your SQL Server Database I/O
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
2011-11-22
3,654 reads
A simple math expression solver
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,948 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