Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » XQuery » SQL Server   (RSS)

Using XML value() method to take advantage of a relational index

The Performance Optimizations for XML Data Type in SQL Server 2005 whitepaper written by Shankar gives some pretty good advice for writing your XQuery statements so that they take advantage of an available XML Index. However, oftentimes you will have Read More...
Posted Thursday, January 05, 2006 11:32 AM by jgalla | 0 Comments
Filed under: , ,

Transforming XML data into a rowset using the nodes() method

Usually there are a couple of scenarios in which you want to take XML data and convert it into a regular relational rowset. In SQL 2000, you probably used OpenXML for this, which works pretty well if you are only working on a single piece of XML data, Read More...
Posted Thursday, December 15, 2005 11:15 AM by jgalla | 5 Comments
Filed under: ,

Using fixed values does not result in smaller instances...

XML Schema has an interesting feature where you can define a value as being "fixed" . The meaning here is basically that an attribute or element has to have a particular value, and if it is not there in the instance, then that value is implied. However, Read More...
Posted Tuesday, November 01, 2005 2:33 PM by jgalla | 0 Comments
Filed under: ,

Answer: Fulltext and XML in SQL Server 2005

A little while ago I threw out this quiz regarding XML and SQL Server 2005's full text search support. As I stated in the quiz, there is a subtle difference between what you can get with contains() and the fulltext support. Specifically, the difference Read More...
Posted Monday, October 17, 2005 4:28 PM by jgalla | 0 Comments
Filed under: ,

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: ,

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: ,

Why is there a 128-byte limit on the primary key for tables with a Primary XML Index?

One error that you may run into when attempting to create a Primary XML Index is the following: Msg 6336, Level 16, State 201, Line 1 Maximum size of primary index of table 'StorageTable' is 900 bytes. CREATE XML INDEX requires that such size should be Read More...
Posted Thursday, August 18, 2005 10:32 AM by jgalla | 4 Comments
Filed under: ,

Consequences of redefining the default element namespace

Check out Mike's entry regarding namespaces in XQuery. I wanted to illustrate one more point regarding the consequences when namespace prefix bindings affect both query and construction. It is about the default element namespace. The real problem hits Read More...
Posted Tuesday, July 12, 2005 10:09 AM by jgalla | 0 Comments
Filed under: ,

Answer: Comparisons in XQuery vs T-SQL

Last week I threw out this simple little quiz . Here is the answer. The first query will return 1 or 0 rows, depending on what the default collation in your database is. On my machine, which uses the default out-of-the-box collation "SQL_Latin1_General_CP1_CI_AS" Read More...
Posted Monday, July 11, 2005 11:03 AM by jgalla | 0 Comments
Filed under: ,

Quiz: Comparisons in XQuery vs T-SQL

I have the following two statements. What is the difference? What would you expect the results to be? Are you surprised by what you get? select 1 where convert(xml, '<foo>bar</foo>').value('/foo[1]', 'nvarchar(4)') = 'Bar' go select 1 where Read More...
Posted Tuesday, July 05, 2005 6:05 PM by jgalla | 2 Comments
Filed under: ,

Denis talks about XQuery static typing in SQL Server 2005

Denis is one of my fellow SDETs on the SQL Server Engine team. He just started a blog about XSD in SQL Server. http://blogs.msdn.com/denisruc/archive/2005/06/13/428726.aspx Static Typing is one of those things that causes a bit of confusion at first for Read More...
Posted Monday, June 13, 2005 8:40 PM by jgalla | 1 Comments
Filed under: ,

Answer: SQL Server 2005 'exist' method

Last week I threw out a quick quiz about the XML datatypes 'exist' method. The reason it was at the top of my mind was that it was a mistake that I had made only a couple of days before. Not only that, but even a couple of my peers didn't recognize the Read More...
Posted Monday, June 13, 2005 12:45 PM by jgalla | 1 Comments
Filed under: ,

Quiz: SQL Server 2005 XML 'exist' method

Among the features introduced in SQL Server 2005 is the new XML Datatype . You can use this guy to store both untyped and typed XML information and maintain the infoset fidelity of the document. We support a subset of the XQuery language which can be Read More...
Posted Friday, June 10, 2005 1:19 PM by jgalla | 4 Comments
Filed under: ,
 
Page view tracker