XML performance tips

XML performance tips
3.8 (75%) 4 vote[s]

Parsing data from XML using XQuery is a routine practice. In order to do this most effectively, little effort is required.

Suppose we need to parse data from the disk file with the following structure:

Use BULK INSERT, if you need to read data from a file:

Read More

Retrieving SQL Server Metadata with Help of T-SQL

Retrieving SQL Server Metadata with Help of T-SQL
4 (80%) 3 vote[s]

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and catalog views. Metadata queries are really helpful in discovering information for a given database schema. You can copy all the T-SQL scripts that are listed in this article and use for your own purposes. However, please do some tests before apply to a production database.

Read More