Welcome to MSDN Blogs Sign in | Join | Help

September 2005 - Posts

Quiz: Fulltext and XML in SQL Server 2005

Using SQL Server's fulltext engine is a great way to optimize your XQuery statements which use XQuery's contains function in a predicate . However, a bit of care has to be taken, because sometimes you might get results which you don't quite expect. Let's Read More...
Posted Friday, September 30, 2005 10:09 AM by jgalla | 0 Comments
Filed under: ,

XQuery Contains vs Fulltext Contains

The XQuery/XPath 2.0 functions and operators specification defines a function called “contains.” It performs a substring match on the two input strings and returns true if the value of the 2nd string is contained in the value of the 1st string. An example: Read More...
Posted Wednesday, September 21, 2005 10:22 AM by jgalla | 3 Comments
Filed under: ,

TEMPDB optimizations for SQL Server 2005 - Help your XML Datatype performance!

http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx Wei mentions a couple of optimizations that can be made for TEMPDB heavy applications. Since XML datatype uses TEMPDB heavily for LOB storage, I recommend checking this out and instrumenting these Read More...
Posted Tuesday, September 13, 2005 12:40 PM by jgalla | 0 Comments
Filed under:

Building an RSS reader in SQL Server 2005

People used to write "Hello, World!" applications in order to demo new languages and technologies. It seems that all of the demos de jour are RSS applications. Well, in order to continue the trend, I have decided to write a quick RSS reader which uses Read More...
Posted Tuesday, September 13, 2005 10:07 AM by jgalla | 1 Comments
Filed under: ,

Seeking on the XML Value Index

This might be long, so I am going to cut to the chase right now. If you are using predicates which involve non-string types in your XQuery statements, you want to use typed data. There, I said it. Now lets try to figure out why. The issue basically boils Read More...
Posted Friday, September 09, 2005 11:32 AM by jgalla | 0 Comments
Filed under: ,
 
Page view tracker