Category Archives: Computer Science

List of Properties’s Values of Class

This script in c# permit to have the list of Values of Properties by Class var props = this.GetType().GetProperties(); var propString = string.Join(Environment.NewLine, props.Select(x => string.Format("{0} = {1}", x.Name, (x.GetValue(this, null) ?? "NULL").ToString())).ToArray());
Read More

Rebuild All Index

DECLARE @TableName sysname declare @cmd varchar(250) DECLARE cur_showfragmentation CURSOR FOR SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName --ind.name AS IndexName, indexstats.index_type_desc AS IndexType, --indexstats.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id WHERE indexstats.avg_fragmentation_in_percent > 30 ORDER BY indexstats.avg_fragmentation_in_percent DESC OPEN cur_showfragmentation FETCH NEXT FROM cur_showfragmentation INTO…
Read More

Query for find SQL Processes and the SQL Command

SELECT sysprc.spid, DB_NAME(sysprc.dbid) AS database_name, sysprc.login_time, sysprc.last_batch, sysprc.status, sysprc.hostname, sysprc.[program_name], sysprc.cmd, sysprc.loginame, OBJECT_NAME(sqltxt.objectid) AS [object_name], sqltxt.text FROM master.sys.sysprocesses sysprc OUTER APPLY master.sys.dm_exec_sql_text(sysprc.sql_handle) sqltxt
Read More