XML

Getting Started With XML Indexes

  • Article

XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running queries against half a million XML employee records. The execution time of a query is reduced from two seconds to being too quick to measure, purely by creating the right type of secondary index for the query.

2012-10-25

2,575 reads

Converting String Data to XML and XML to String Data

  • Article

In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.

2012-02-07

4,207 reads

Incorporating XML into your Database Objects

  • Article

XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions. Robert Sheldon explains how.

2012-01-20

2,557 reads

The XML Methods in SQL Server

  • Article

The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.

2012-01-03

3,706 reads

Blogs

Database Fundamentals #22: Using the Join Operator, CROSS JOIN

By

While the CROSS JOIN is not used much, and, depending on the size of...

Automate Your SQL Notebooks with Two New Options

By

There are two new options for automating your SQL Notebooks with your SQL Servers....

Debugging techniques (focusing on T-SQL)

By

tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems....

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Log_Reuse_wait_Desc 'AVAILABILITY_REPLICA'

By Syed_SQLDBA

I have a very small DBs (3 GB) but I noticed that the size...

Publishing article revision updated intro comment date in article forum

By Solomon Rutzky

I recently revised an article, https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-2-sample-stored-procedure-and-function , and just noticed that, in the article-specific forum...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers