Sign in
John Gallardo's Weblog
From Windows Phone
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
LinqToSql
Microsoft
Personal
rsExecutionNotFound
SQL Server
SSRS
Windows Phone
XQuery
Archive
Archives
May 2011
(2)
May 2010
(1)
June 2009
(1)
March 2009
(1)
February 2009
(1)
January 2009
(2)
August 2008
(1)
July 2008
(1)
June 2008
(1)
March 2008
(3)
December 2007
(1)
October 2007
(1)
September 2007
(1)
June 2007
(1)
May 2007
(1)
March 2007
(2)
February 2007
(1)
January 2007
(3)
December 2006
(2)
November 2006
(1)
October 2006
(2)
August 2006
(3)
June 2006
(1)
March 2006
(1)
January 2006
(3)
December 2005
(1)
November 2005
(3)
October 2005
(3)
September 2005
(5)
August 2005
(2)
July 2005
(8)
June 2005
(7)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
John Gallardo's Weblog
Quiz: Fulltext and XML in SQL Server 2005
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
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. ...
John Gallardo's Weblog
XQuery Contains vs Fulltext Contains
Posted
over 8 years ago
by
John Gallardo [MSFT]
3
Comments
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...
John Gallardo's Weblog
TEMPDB optimizations for SQL Server 2005 - Help your XML Datatype performance!
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
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...
John Gallardo's Weblog
Building an RSS reader in SQL Server 2005
Posted
over 8 years ago
by
John Gallardo [MSFT]
1
Comments
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...
John Gallardo's Weblog
Seeking on the XML Value Index
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
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...
Page 1 of 1 (5 items)