O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Knowledge Measure

  1. What XML parser does SQL Server's XML features use?

  2. True or false: The NESTED option can be used only in client-side FOR XML.

  3. What extended stored procedure is used to prepare an XML document for use by OPENXML?

  4. What's the theoretical maximum amount of memory that SQLXML will allow MSXML to use from the SQL Server process space?

  5. True or false: There is currently no way to disable template caching for a given SQLISAPI virtual directory.

  6. Describe the use of the sql:mapping attribute from Microsoft's mapping-schema namespace.

  7. Why is the maximum mentioned in question 4 only a theoretical maximum? What other factors could prevent MSXML from reaching its maximum memory allocation ceiling?

  8. What XML support file must you first define before ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required