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)
24,698 reads
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-17 (first published: 2008-09-12)
24,698 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,135 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,641 reads
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...
I have a table with varbinary datatype (file stream enabled) column which store pdf...
I inherited a fairly large system with a couple dozen servers (1/4 physical, the...