
Problem solve
Get help with specific problems with your technologies, process and projects.
XML in SQL Server
An introduction to XML shredding for SQL Server
It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach.Continue Reading
Processing XML files with SQL Server functions
The procedure of loading XML files onto a SQL Server database and processing them into tables is not well documented. Discover a prescribed method that uses both SQL Server functions and XPath expressions.Continue Reading
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you ...Continue Reading
-
Create a computed column in SQL Server using XML data
In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition.Continue Reading
Create DDL table in SQL Server 2005 to audit DDL trigger activity
Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert...Continue Reading
Retrieve XML data values with XQuery in SQL Server 2005
When you want to access specific XML data values -- instead of XML as a single data type value -- the XQuery is the scripting language you're looking for. Microsoft designed XQuery specifically to access XML data in SQL Server 2005, allowing you to ...Continue Reading
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
When choosing to use the XML data type or the VARCHAR (MAX) data type, in SQL Server 2005, DBAs and developers should know the potential performance impact of each. Here's a look at two tables, one inserted and queried with XML and the other with ...Continue Reading
How to display the XML result of 'Select For XML Explicit'
Try the XML View Mapper
What it gives you, what it can do.Continue Reading
SQL Server support for XML
New clause that allows easy data manipulation.Continue Reading
-
SQL Server 2000 and XML
A look at some of SQL Server 2000's integrated XML support.Continue Reading
Get SQL Server table structure in XML format
Here is a quick stored procedure in SQL Server 2000 that returns the table structure in XML format.Continue Reading
Retrieving newly-inserted primary keys in SQL Server 2000
How to use @@IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT to retrieve newly-inserted primary keys in SQL Server 2000.Continue Reading
Inside look at SQLXML technologies
This chapter describes how SQL Server's XML technologies are designed and how they fit together from an architectural standpoint.Continue Reading
Transferring SQL Server data into XML format