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,088 reads
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-17 (first published: 2008-09-12)
25,088 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,288 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,811 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers