Do they both show up in sys.assemblies?

select * from sys.assemblies

What other references are there in either of the assemblies?

Not necessarily, it means that there are none in the current data in the ring_buffer target. The ring_buffer is a in memory target and works in a FIFO manner...

Looking at the XQuery code a year later, I do see that there are some things that are not necessarily written well. Try this one out:

select CAST(

REPLACE(

REPLACE(XEventData.XEvent.value('(data/value)[1]', 'varchar(max)'),

'<victim-list>',...

You probably have a lot of events in the ring_buffer target that is causing the XML parsing to be slow. What is the output of SELECT @@VERSION on the...

Just a sample of what will be in my session on querying the plan cache at PASS Summit this year. 🙂

This should get your pretty close, but I am going to provide fair warning that it takes a long time to execute, depending on the size of your plan cache,...

Did you add a certificate for Server Authentication from a trusted CA to the server and follow the steps and information outlined in the books online?

http://technet.microsoft.com/en-us/library/ms189067.aspx

Sorry, but without code its impossible to help you solve this. Take a little bit of time and mock up a similar scenario using different information. I can...

Doing data access in a user defined function, whether it be TSQL or CLR is really slow because it is a RBAR (row by agonizing row) process. Without code...

Maybe, but its easy to be critical from the...

I don't definitively know why Microsoft made the engine work that way, but I do know that SQL Server doesn't have a file handle to an Offline Database, so its...

Striped backups require that all files be available to restore the database since the data is striped across the backup devices when the backup stream is being written. The...

All file operations in SQL Server are handled through the file managment functions in the Win32 API which are documented in the Books Online Topic File Management Functions.

This was documented...

The same way you would from a batch file or from a command prompt. Generally you can create a batch file to test your commands and develop your automation...

Is this for a system that you plan on, or currently sell? If so I'd recommend using a SQL Agent job with a CmdExec step that does this. ...