Choosing Paths for Selective XML Index – Part 2 – Using the SXI XEvents
In part 1 of this series, we tried a simple example from the Books Online without any SXI index at all, and an SXI with
Menu
In part 1 of this series, we tried a simple example from the Books Online without any SXI index at all, and an SXI with
About a month ago, I wrote a series of blog entries on the Selective XML Index introduced in SQL Server 2008 SP1. Just to summarize
OK. VM with the SP1 CTP is shut down. Fun's over (until I think of something new and cool or you think of something and
Experimenting without docs is a good way to get lots of error messages along the way. I'm learning by attrition, and it seems like I'd
I've only been talking so far about the "primary" Selective XML Index. But you can also create 0-n "secondary" Selective XML Indexes. The syntax looks
A while after I posted part 1, there was a twitter message from Aaron (@AaronBertrand), a well-known "smart person" in the SQL Server space, about
OK, so let's try something. Load a bunch of documents. Although, actually this part works with an empty table. create selective xml index fooidx2 on
So, it was announced that SQL2012 SP1 CTP4 was released yesterday. You've likely already heard this (more than once, everyone seems to revel in repeating
While preparing for my TechEd talk on filetables and full-text search, I came across this tidbit that I thought was interesting. With the advent of
This post is an example of the "bring your own problem" approach in the classroom, inspired by upcoming SQLskills Immersion Events in August. See previous
I've said before how thrilled I am will the new extended event UI in SSMS for SQL Server 2012. However, you might be one of
SQL Server 2008 adds support for the 'let' clause in FLWOR expressions. The for and let clauses have a similar purpose, to bind content (tuples)
Michael Rys (and who would know better/sooner about this) just announced on his blog that XQuery 1.0 and associated specs (including XPath 2.0 and XSLT 2.0)
There's an interesting article that caught my attention in this month's (July 2006) MSDN magazine by John Mollman about building the MSDN aggregation system. The
I've been looking at the DLINQ syntax a bit more (I'm participating in a BOF at TechEd next week), and its always struck me how,
While teaching SQL Server 2005 to developers, I'd always point out the irony in the fact that the new EVENTDATA() function, used to return information
If I store XML in an XML data type column its sometimes useful for performance to be able to hoist the value of a particular
I've always been slightly puzzled by the permission "EXECUTE" on an XML SCHEMA COLLECTION. Say I have an XML SCHEMA COLLECTION named MySchemas and a table
After speaking yesterday and recanting my story (for about the 100th time) about EventData being XML as a “nefarious plot” to require DBAs to learn
OK, because it was Michael that asked originally, XML/XQuery wishes for SQL Server 200x. In no particular order. Full compliance with "standard" W3C XQuery. If
I've been working on a student question about using Impersonation inside of a stored procedure. This one's worth sharing. You can do impersonation using the
Here's something I've noticed you can do with SQL Server 2005 and Visual Studio 2005. Take a set of XML documents with the same basic
One of the nice surprises in the April CTP is that SQL Server 2005 XML schema validation errors come with a location now. That's handy.
I've always liked the graphic showplan in SQL Server query analyzer. The biggest hassle with it came when you wanted to send the plan to
When reading the CTPNotes file from the new Feb CTP build I stumbled across the fact that the XML schema that contains SQL data types
Here’s the answers to the question from Fun With static XQuery evaluation – 2 — start with a schema collection CREATE XML SCHEMA COLLECTION ages
After the last two entries, you might be thinking "I guess I can never use text() as a node test with typed XML again". Not
Reference back to the previous entry. Now that we know the rules, let's try them out: — snip — Data(),text() and string() accessors XQuery has
There's been lots of puzzled faces lately when I try to explain doing XQuery against strongly typed XML (XML typed by a SCHEMA COLLECTION) vs
Haven't been blogging as much recently, as I've been teaching and travelling quite a bit. Last week though, I received an interesting query on XQuery
HTTP Endpoints in SQL Server 2005 are normally a way to support SQL Server clients that speak the SOAP protocol. It turns out that, although
Another little thing I'd found had changed in Dec CTP. I'd reported a bug on this one and knew it was gonna be fixed eventually,
OK, I couldn't help myself. The Dec 2004 CTP-specific readme had quite a number of things that are new. There are many improvements in SSIS, for
When you retreive a rowset that contains an XML data type column or use an XML data type column as parameter input, you have two
Every time I demonstrate using XQuery against a table that contains an SQL Server XML data type to a new class, a get about one
And now, for something a little technically lighter… I've taken to using a convention when writing statements that involve XML/XQuery and SQL together. I put
Rereading the post about this from last night, it appears that I may have used an ambiguous analogy when attempting to figure why this feature works
Dan Sullivan pointed this out to me a couple of weeks ago. I'd forgotten about it, but it came back to bite me in a
I've known for a couple of weeks now that XQuery and the new XML-SQL client mapping have been dropped from System.Xml in .NET 2.0. The
A few weeks ago, I was surprised by an error message when attempting to create an HTTP endpoint with CREATE ENDPOINT. The error was "You
After lots of interesting (but fruitful) experiences with the XQuery engine in SQL Server 2005, I decided that I'd rather have an XML schema collection
With the introduction of the XML data type (using an XML data model) comes there's a choice of pulling XML out of the database as
SQL Server 2005's HTTP endpoint functionality uses http.sys, the HTTP stack in the kernel, to do it's processing. Until lately Windows Server 2003 was the
Some folks have asked why I appear to use the XQuery data() function on occasion, but not always, when I'm doing demos. If you want
I've been trying out the new session support in HTTP endpoints. You manipulate this through SOAP headers, and looking through the list of SOAP headers
As Mark Fussell will tell you, one of the coolest things in System.Xml 2.0 is the static creator methods on XmlReader and XmlWriter. It made
About a month ago, there was another chapter in the long discussion about DataSets and web services. An old cohort Scott Hanselman fired off the
I was checking some of the SQL Server 2005 features on the way over on the plane. The latest build that I have is SQL
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.