ANSI PADDING, Trailing Whitespace, and Variable Character Columns
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-17 (first published: 2008-09-12)
25,320 reads
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-17 (first published: 2008-09-12)
25,320 reads
This is probably part 1 of a series, but no guarantees.
Why Certify?
I've been working with SQL Server for 10 years...
2010-03-19
1,842 reads
The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...
2010-02-26
563 reads
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-02-05
1,755 reads
2010-01-12
667 reads
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
2009-10-30
1,205 reads
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-14
1,825 reads
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-17
1,143 reads
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
2009-06-15
4,404 reads
This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.
2009-04-16
10,936 reads
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Hello all, I am hoping that this is an easy question and I'm just...
The problem was reported to us by a customer. They shared a graphic execution...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers