DECLARE @DM_FASCICOLIId BIGINT; SET @DM_FASCICOLIId = 6; WITH DMFASCICOLI AS ( SELECT * FROM DM_FASCICOLI WHERE ID_Padre = @DM_FASCICOLIId UNION ALL SELECT DM_FASCICOLI.* FROM DM_FASCICOLI JOIN DMFASCICOLI ON DM_FASCICOLI.ID_Padre = DMFASCICOLI.Id ) SELECT *, dbo.Dm_Fascicoli_GetFullPath(id) FROM DMFASCICOLI OPTION(MAXRECURSION 32767)
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 per individuare i processi attivi su SQL e la Query eseguita
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 [objec
Read More
Funzione per recuperare ogni singolo carattere ascii da un Campo
DECLARE @Lunghezza int, @Carat varchar(10), @ValueAscii varchar(10), @x int, @valore varchar(1000) set @valore = (SELECT CAMPO FROM TABELLA WHERE ...) set @Lunghezza = (select len(CAMPO)FROM TABELLA WHERE ...) set @x= 0 while @x <> @Lunghezza begin set @Carat = SUBSTRING(@valore,@x,1) set @ValueAscii = ASCII(@Carat) print 'Carattere:' + @Carat + ' Ascii: ' + @ValueAscii set…
Read More