2012-01-12 (first published: 2010-07-07)
8,814 reads
Articles
Grant Fritchey's SQL Server Howlers
We decided to ask various well-known SQL Server people to write about their favorite SQL Server Howlers. These are those common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions. Grant Fritchey opens the series with some of those howlers that stick in the mind.
2012-01-12
4,268 reads
Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012
The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.
2012-01-11
3,322 reads
Dynamically create and populate staging tables from CSV files
This SSIS package reads the first line of a CSV file to obtain field names, then creates a table based on those field names and loads the remaining lines into the table.
2012-01-10
13,907 reads
Raw Materials - Order! Order!
Leibniz breaks out of a buyer's dilemma that might defeat a subtler mind.
2012-01-10 (first published: 2010-06-30)
9,265 reads
SQL Test: Seeing Red Change to Green
Rob Sullivan is one of the users who are helping shape the way that SQL Test develops, and here he explains what is going on, and why.
2012-01-10
1,883 reads
SSMS Shared SQL Templates
This article describes how to use the built in repository for SQL Server Management Studio Templates and how to customize and share a common repository with your team.
2012-01-09
9,070 reads
Constraints and the Test-Driven Database
Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause consequential severe financial damage. It is perhaps better seen as creating a test-driven database.
2012-01-09
2,574 reads
TSQL Challenge 73 - Implement Word Wrapping in TSQL
The challenge is to wrap the text by specified position.
2012-01-09
2,883 reads
Understanding and Using APPLY (Part 1)
The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.
2012-01-06 (first published: 2010-04-12)
52,787 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