Covering a Query That Includes an XML Column

It's great to type a column as XML to leverage schemas and XML indexes, but right now we can't add an XML column to an index, even as an included column. So what do you do when you have a query that is generating a bookmark lookup because of the XML column? One solution is to stop using XML, not a great solution, and another is the one we demonstrate - creating a computed column that we CAN include in an index. It's not a technique to use casually, but it will remove the bookmark lookup!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Kevin Bayer on 12/27/2010

Excellent...I was just looking into this...

Cheryl on 12/27/2010

When creating the index, why is Demographics2 added with an INCLUDE instead of just part of the index with the other the column names?

Nilesh on 12/28/2010

nice

Jamshid Nouri on 12/28/2010

very nice demo

Ratan Kalwa on 12/28/2010

Good one.

Eric Moreau on 12/28/2010

even with the warnings in the recap, I am really not sure this tweak is a good idea to broadcast!

Leonard Peoples on 12/28/2010

That was interesting. Can you guys show a video explaining how INCLUDE (on the index) works? Thanks.

995751D667 on 12/29/2010

Very informative

Michael Sidley on 12/29/2010

Well done just not relevant for me.

jciechanowski on 12/30/2010

"what do you do when you have a query that is generating a bookmark lookup because of the XML column" what causes a bookmark lookup?

Desmond Cassidy on 1/2/2011

Very obtuse and very insightful

Prerna on 1/5/2011

good one

Kasey Wheeler on 1/14/2011

Great video

Maurice Ivory on 2/11/2011

I just really was't into this one.

MohanD on 12/10/2011

Excellant

Michael on 2/8/2012

Excellent