Home
Topics
Microsoft SQL Server Database Development
XML in SQL Server

The case for XML shredding in 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 expr...
Manage traces in Analysis Services 2005 with XMLA

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

XML in SQL Server

Email Alerts

Register now to receive SearchSQLServer.com-related 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

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. Tip
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. Tip
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. Tip
Return all values in a comma-delimited string

This script will return one big string where the rows are separated by a comma. Tip
Returning a result set in random order

At times you might need to return the SQL Server data to the client in a random order. Here's how. Tip
XML support in SQL Server 2000

A detailed introduction to the three ways you can use XML in SQL Server 2000, with lots of code samples. Tip
NVARCHAR vs VARCHAR in SQL Server 2000

Overcome some conversion and performance problems by forcing SQL Server 2000 to behave the same way as earlier versions. Tip

1
2

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Real-time data analytics aims to boost businesses' speed of thought
  
  Real-time business intelligence can help improve operational decisions by enabling BI to be done in business systems. Read about how to make it work.
- Strata speaker calls for increased focus on data scientist education
  
  Society should do more to encourage the next generation of data scientists, according to a speaker at last week's O'Reilly Strata Conference.
- Strata speaker cites key characteristics for success in data science
  
  Senior research scientist Rachel Schutt offers a rundown of the common traits shared by people who have been successful in the field of data science.
Data Center
- Desktop market matures but VDI challenges remain
  
  Tools enable companies to reduce support costs, boost security and lower energy consumption, but more is needed to overcome VDI challenges.
- Cloud, converged systems make server hardware future murky
  
  Server hardware has ruled the data center landscape for many years, but may be usurped as enterprises embrace converged systems and other new tech.
- Using Zabbix with embedded devices via SNMP monitoring
  
  Some devices you want to monitor with Zabbix cannot have software installed. For these appliances, SNMP monitoring may be the right choice.
Data Management
- Data management platform adds analytics for digital marketers
  
  Data management platform Crowd Control puts more analytics power into the hands of digital marketers and media buyers.
- Motorcycle icon Yamaha updates dealer site with fast database drivers
  
  Database drivers are sometimes an afterthought. But JDBC drivers came to the fore when Yamaha Motor Europe rebuilt its e-commerce website for dealers.
- Business intelligence and data warehousing trends aired at TDWI event
  
  In a podcast, TechTarget editors detail the business intelligence and data warehousing topics discussed at the 2013 TDWI conference in Las Vegas.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle Database Appliance x3-2 due out Tuesday
  
  A major upgrade to the Oracle Database Appliance x3-2 gives it some of the Exadata platform's high-end features, although it isn't quite there yet.
- Weigh the benefits of Oracle on mainframe vs. x86
  
  Until recently, big databases always meant using big iron. But as software and hardware evolves, Oracle on mainframe is becoming less common.
- Managing the cost-based optimizer in E-Business Suite
  
  An OAUG board member and Oracle Applications DBA explains how to use the cost-based optimizer to manager E-Business Suite stats.
Content Management
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
- Podcast: Who should be in charge of an enterprise search deployment?
  
  Organizations looking to set up an effective enterprise search deployment need to carefully consider the person they pick to lead the initiative.
Windows Server
- Seven things to know about Windows Server 2012 deduplication
  
  It's no magic bullet, but Windows Server 2012 deduplication can help alleviate rising data storage demands.
- The greening of Windows Azure: Microsoft ready to take on AWS
  
  Microsoft's Windows Azure strategy -- integration with System Center 2012 and a low price -- make it a viable alternative to AWS for cloud computing.
- Overcoming Server Core installation woes in Windows Server 2012
  
  Don't run away from a Server Core installation in Windows Server 2012. Follow these simple steps for a successful transition.

All Rights Reserved,Copyright 2005 - 2013, TechTarget