Secondary XML Indexes

Question

Secondary XML Indexes

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
March 13, 2015 at 12:13 am

#74424

Comments posted to this topic are about the item Secondary XML Indexes
March 13, 2015 at 3:48 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287024 More actions · Answer 2

I must admit that I don't use XML very much. It's does store very flexible data structure, but it just doesn't perform well. Thanks for the question.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SqlMel SSCrazy Points: 2901 More actions · Answer 3

Thanks for the question, Steve.

---------------
Mel. 😎

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 4

RK Mandava

SSCarpal Tunnel

Points: 4153

March 13, 2015 at 7:23 am

#1783854

Nice question, thanks

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

March 13, 2015 at 9:22 am

#1783926

Simple and nice. Thanks, Steve!

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Nice and simple. But I avoid XML like the plague.

Tom

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 7

Ed Wagner (3/13/2015)
I must admit that I don't use XML very much. It's does store very flexible data structure, but it just doesn't perform well. Thanks for the question.

TomThomson (3/14/2015)
Nice and simple. But I avoid XML like the plague.

Heh... ditto those especially Tom's. A better question would be why would anyone in their right mind store XML in a database ever?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Jeff Moden (3/14/2015)
Ed Wagner (3/13/2015)
I must admit that I don't use XML very much. It's does store very flexible data structure, but it just doesn't perform well. Thanks for the question.
TomThomson (3/14/2015)
Nice and simple. But I avoid XML like the plague.
Heh... ditto those especially Tom's. A better question would be why would anyone in their right mind store XML in a database ever?

Actually there can be good reasons to store XML in a database - just as there can be reasons to store text strings. I imagine that Neos Interactive is now storing XAML in SQL Server databases, because the Beirut team was heading that way (with encouragement from me) when I handed over all tecnical responsability to them - not that the database will be looking into the XAML, I hope, just holding it and delivering it when the presentation layer wants something like "the string used for the XYX field in the UVW screen of the RST GUI in the OPQ language as spoken in LMN coutry/region". Of course the XAML fields will be held as NVARCHAR(3600) and the database will not be aware that these fields contain values in an XML-based language, and although XML is OK when used appropriately (in this instance as part of a GUI implementation using WPF) there can be no excuse for having any XML indexes or being able to treat XML within the database as anything other than an atomic string attribute with no internal structure. We were using NVARCHAR(3600) strings of text in English, French, German, two varieties of Chinese, and Russian up to 2009 but decided to upgrade to using WPF (and hence XAML) at the same time as upgrading from SQL Server 2000 to 2008 (or 2008 R2).

Tom

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Ed Wagner (3/13/2015)
I must admit that I don't use XML very much. It's does store very flexible data structure, but it just doesn't perform well. Thanks for the question.

+ 1 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant