Collation, DateTime, SParse Column and XML

In SQL Server, each string type, such as varchar, nvarchar, text, ntext associate with a collation no matter whether you specified or not during creation time. If your app just works fine and you never deal with collation explicitly or you even don...

Hello, Guys We have a conversation about how to implement a name/value pairs in our internal forum. I like to share your guys about this: Question: I am about to create EAV based tables to store name / value pairs. I am kind of f familiar...

Several days ago, one customer asked me a question about collation. Here is the question: My applications requirement to search English characters along with accent characters like (å, Å), If we search Name “James “ by my application it should return...

In SQL Server, the binary collation (collation name ending with BIN2) use an algorithm which directly compare the code page of the characters. In other word, it is not linguistic sorting. However, it happens that it can sort alphabet and numbers correctly...

Hello, In this blog entry, I will provide a list of topics I will cover in further blogs. When to use and How to use Filtered Indices. Introduce to the Column Set XML Column and Wide Table feature in SQL Server 2008 Redesign the Project...