Velniai

Velniai / xml_serialze.cs

Created May 26, 2019 18:38

[C# XML] #c# #xml

XmlDocument document = new XmlDocument();

Velniai / Indexes Usage Stats.sql

Last active September 16, 2019 05:36

[Index Maintainance] #sql #index #dmv

	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