Compartir a través de


Collation, DateTime, SParse Column and XML

SQL Server’s Binary Collations

Today, I will discuss SQL Server’s Binary collations. In SQL Server, we have two kinds of binary...

Author: QingsongYao Date: 04/06/2009

my draft thought

Focus: Test Design, Coding Style, Not Test PattersWhat is the problem ? In general, we will avoid...

Author: QingsongYao Date: 04/02/2009

my thought

  1. The best way of teaching others or sharing experience to others is to make them thinking. No...

Author: QingsongYao Date: 03/27/2009

Be aware of comparing unicode constant with varchar column (updated)

Today, I looked for SQL Server JDBC Driver's sendStringParametersAsUnicode, this parameter controls...

Author: QingsongYao Date: 03/26/2009

Is Datetime2 compliant with Daylight Savings Time?

Today, I got following questions:"The documentation states that Datetime2 is unaware of the time...

Author: QingsongYao Date: 03/12/2009

Why I write so many collation topics?

You may wonder why I keep writing collation topics in my blogs. I found our Books Online topics...

Author: QingsongYao Date: 03/11/2009

Got Collation conflict, How to avoid this?

The best way to avoid SQL Server's collation conflict issue is that avoid have different collations...

Author: QingsongYao Date: 03/11/2009

GB18030 Character Set Support in SQL Server

Recently, I got several request related to GB18030 Character Set support in SQL Server. Here is one...

Author: QingsongYao Date: 02/24/2009

My recommendation of SQL Server’s Globalization Development

Normal 0 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable...

Author: QingsongYao Date: 02/24/2009

UTF-16 Encoding and SQL Server (4) - String Function Case Study

Normal 0 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable...

Author: QingsongYao Date: 02/13/2009

UTF-16 Encoding and SQL Server (3) - Length Semantic

As you discuss in here and here before, in order to supporting UTF-16 encoding in SQL Server, we...

Author: QingsongYao Date: 02/05/2009

UTF-16 Encoding and SQL Server (2)

Normal 0 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable...

Author: QingsongYao Date: 02/02/2009

UTF-16 Encoding and SQL Server (1)

Normal 0 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable...

Author: QingsongYao Date: 02/01/2009

Do we need a case insensitive binary collaton?

In SQL Server, the binary collation (collation name ending with BIN2) use an algorithm which...

Author: QingsongYao Date: 01/29/2009

Changing collation of a column is not so trival

Several days ago, one customer asked me a question about collation. Here is the question: My...

Author: QingsongYao Date: 01/09/2009

A conversation about how to implement Name/value pairs

Hello, Guys We have a conversation about how to implement a name/value pairs in our internal forum....

Author: QingsongYao Date: 01/09/2009

Hello, In this blog entry, I will provide a list of topics I will cover in further blogs. When to...

Author: QingsongYao Date: 01/08/2009

Using SQL Server 2008 Semi-Structured features for Performance Tuning and Application Design (1)

Before I talk with the examples of semi-structured property management system, I like to define the...

Author: QingsongYao Date: 09/10/2008

Sparse Column Storage

In SQL Server 2008, we implemented a set of features, including Sparse Column, Column Set + Wide...

Author: QingsongYao Date: 09/03/2008

SQL Server 2008 (Katmai)'s new collations

In SQL Server 2008 release, a number of new collations were added. You can get the list of 79 new...

Author: QingsongYao Date: 08/25/2008

Conversion from string to datetime2, time, date is timezone un-awared

In SQL Server 2008, An instance of DateTimeOffset type can represent: 1) A local time + a time zone...

Author: QingsongYao Date: 08/18/2008

Why should we bother about Surrogate characer?

Today, someone ask following questions: 1. We know that the Surrogate Characters have two bytes when...

Author: QingsongYao Date: 08/11/2008

The resolution of SYSTEMDATE function

In SQL Server 2008, the datetime2, time, and datetimeoffset types can have a optional fractional...

Author: QingsongYao Date: 08/05/2008

Colon(:) and dot (.) in factional second is not the same

Colon and Dot are two symbol to separate the second and factional second in a given time string. If...

Author: QingsongYao Date: 08/04/2008

Idea about implementing a time internal type in SQL Serve 2008

In SQL Server 2008, we implement several new date and time types which follow the ISO SQL standard....

Author: QingsongYao Date: 08/01/2008

My first blog

Hello, guys Welcome to my blog. I am a tester in SQL Server Engine Team. I tested the SQL Server 's...

Author: QingsongYao Date: 07/31/2008

<Previous