Velniai

## xml_serialze.cs
XmlDocument document = new XmlDocument();

## Indexes Usage Stats.sql
DECLARE @TableName VARCHAR(20) =  NULL

SELECT	TableName		= OBJECT_NAME(S.object_id),
		IndexName		= I.name,
        UserSeeks		= S.user_seeks,
        UserScans		= S.user_scans,
        UserLookups		= S.user_lookups,
        UserUpdates		= S.user_updates ,
		IsPrimaryKey	= i.is_primary_key
FROM    sys.dm_db_index_usage_stats S
	DECLARE @TableName VARCHAR(20) = NULL

	SELECT TableName = OBJECT_NAME(S.object_id),
	IndexName = I.name,
	UserSeeks = S.user_seeks,
	UserScans = S.user_scans,
	UserLookups = S.user_lookups,
	UserUpdates = S.user_updates ,
	IsPrimaryKey = i.is_primary_key
	FROM sys.dm_db_index_usage_stats S