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
- 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
My future posting related to semi-structured.
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