Microsoft SQL Server Database Development

Email Alerts

Register now to receive news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.

  • 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.

  • 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 need to know to create, alter and delete traces with ease.

  • 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.

  • 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 Robert Sheldon walks you through designing the audit table, defining the DDL trigger and then testing the auditing solution.

  • 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 retrieve XML columns, variables and parameters. In this tip, you'll learn how to use two XQuery methods within your T-SQL statements: Value() to retrieve a single XML value and Query() to retrieve multiple XML values.

  • 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 the VARCHAR (MAX) data type. Take a look at the CPU and I/O results and make the best data type choice for your SQL Server environment.

  • XQuery

    XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like.

  • Commerce XML (cXML or Commerce Extensible Markup Language)

    Commerce XML (cXML) is a standard for the online exchange of business transaction information in common formats.

  • How to display the XML result of 'Select For XML Explicit'