Tags » XQuery

SQL Server - Extended Event - Metadata - Get Current Target File


For some optimization work that we are doing, I will like to know the name of the Extended Events’ Engine currently targeted file.

Code… 109 more words


XPath Query Tools - XmlToolBox


Lately I have been working more and more with Extended Events and prior to that Cached Plans exploration.

And, has both are stored as XML, it makes sense to see what tools are available for accurately querying XML data. 740 more words


SQL Server - Extended Events - Querying Data - Day 1


Once we have our Extended Events Session Setup and it is collecting data, we should occasionally check in and review the collected data.

Sample… 474 more words


SQL Server - Extended Events - Metadata


In our last post, needed to back port an Extended Event Session developed in SQL Server 2014 to v2008/R2.

Unfortunately, the exported script did not work in our initial attempt to apply against the v2008-R2 Instance. 954 more words


Using Extended Events Telemetry Session

You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session known as telemetry_xevents that is shipped with SQL Server 2016. 1,767 more words


How To : Access Oracle Sequence from XQuery

In this new post, we’ll see how to access an Oracle sequence from an XQuery expression.
I already wrote about a similar topic a few years ago, in… 2,022 more words