The following W3C XQuery 1.0 and XPath 2.0 Functions and Operators specifications diagram shows the built-in data types. This includes the built-in primitive and built-in derived types.
Other News
How to filter data from an XML file into a DataGridView
(Ged Mead) I saw an interesting question on VBCity recently where the need was to take data from an XML document, store it in a dataset, populate a DataGridView, and also allow users to select specific data that met their search criteria.
Cardinality Feedback in 11.2
(Hemant K Chitale) The (undocumented) CARDINALITY Hint has been available since 10g. This allowed the Developer / DBA to “hint” to Oracle the expected number of rows that will be returned from a table that is part of a query.
Subterranean IL: Filter exception handlers
(Simon Cooper) Filter handlers are the second type of exception handler that aren’t accessible from C#. Unlike the other handler types, which have defined conditions for when the handlers execute, filter lets you use custom logic to determine whether the handler should be run.
Data Studio and DB2 for z/OS Stored Procedures
(Paolo Bruni and Marichu Scanlon) Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered ever-improving support for developing and operating stored procedures.
Second Episode of DB2 has Talent
(Susan Visser) On today’s DB2Night Show, we had the second set of competitors who are competing in the DB2 has Talent Competition. This week we had 6 amazing competitors who made it difficult for we judges (Martin Hubel, Klaas Brant, and I) to choose who would move on to the finals.
What should be considered when NOLOCK hint is used
(Mika Wendelius) With SQL Server the NOLOCK hint is very tempting especially with SELECT statements where at least one of the tables is frequently updated. Using the NOLOCK removes all queueing problems and the SELECT statement runs smoothly, but not without side effects.
Sampling SQL server batch activity
Recently I was troubleshooting a performance issue on an internal tracking workload and needed to collect some very low level events over a period of 3-4 hours. During analysis of the data I found that a common pattern I was using was to find a batch with a duration that was longer than average and
SharePoint 2010 User Profile Service: Part 4 Configure UPS Synchronization Sources
(Mohamed M Malek) In the previous post I showed you how to deploy the BCS model for the Employee WCF service. In this post we will continue our scenario by adding the synchronization sources for the AD and the BCS WCF service.
SQL SERVER – Capturing Wait Types and Wait Stats Information at Interval – Wait Type – Day 5 of 28
(Pinal Dave) Earlier, I have tried to cover some important points about wait stats in detail. Here are some points that we had covered earlier.