Tags » XQuery

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

Background

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

Microsoft

XPath Query Tools - XmlToolBox

Background

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

Microsoft

SQL Server - Extended Events - Querying Data - Day 1

Background

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

Microsoft

SQL Server - Extended Events - Metadata

Background

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

Microsoft

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

SQL SERVER

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

HowTo