Cleaning up excess contiguous spaces in strings. A mystery.
/* Have you ever come across the problem where you have to remove spaces from a string that has too many?...
2010-09-30
2,979 reads
Blog Posts
Dear Users…Sincerely, Your IT Guys
Dear Users,
We, the tech people, understand that you just want technology to work so you can get your jobs done. ...
2010-09-30
1,711 reads
Geekbench 2.1.7 Released
If you read my blog or follow me on Twitter, you know that I have a strong interest in database...
2010-09-30
1,664 reads
No Guarantees
The keynote for SQL Saturday #52 in Denver, that didn’t go as smoothly as I’d like due to technical difficulties,...
2010-09-30
1,520 reads
PASS Summit Schedule
Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit. You...
2010-09-30
1,555 reads
Revisiting The West Wing
Sometimes spending some time with your spouse watching TV is right up there with comfort food, the challenge is often...
2010-09-30
1,429 reads
SQL Saturday 52 Recap
I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver. This was the...
2010-09-30
2,935 reads
SQL Server 2008 Service Pack 2 Released
Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack...
2010-09-30
1,690 reads
Stupid Tech Support Tales
One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log:
"9/22/2010...
2010-09-30
1,483 reads
When the Bloc Québécois is a Nuisance for Quebeckers’ Interests: The Top 20 Countdown
The below is a republished version that has been released officially on the Canadian Federal Liberal Party's web site. Finally...
2010-09-30
8,720 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers