Reginaldo Barros RegisBarros

🎯

Focusing

Web Development since 2010, Gamer and Palmeirense

RegisBarros / TaskQueue.cs

Created August 16, 2022 20:30

Task

	public class TaskQueue
	{
	private readonly ConcurrentQueue<Func<Task>> _processingQueue = new ConcurrentQueue<Func<Task>>();
	private readonly ConcurrentDictionary<int, Task> _runningTasks = new ConcurrentDictionary<int, Task>();
	private readonly int _maxParallelizationCount;
	private readonly int _maxQueueLength;
	private TaskCompletionSource<bool> _tscQueue = new TaskCompletionSource<bool>();

	public TaskQueue(int? maxParallelizationCount = null, int? maxQueueLength = null)
	{

RegisBarros / pubsub.js

Created October 18, 2017 15:40 — forked from learncodeacademy/pubsub.js

Basic Javascript PubSub Pattern

	//events - a super-basic Javascript (publish subscribe) pattern

	var events = {
	events: {},
	on: function (eventName, fn) {
	this.events[eventName] = this.events[eventName] \|\| [];
	this.events[eventName].push(fn);
	},
	off: function(eventName, fn) {
	if (this.events[eventName]) {

RegisBarros / QueryToFindExecutadedQuery.sql

Created October 10, 2017 01:01 — forked from rodolfofadino/QueryToFindExecutadedQuery.sql

QueryToFindExecutadedQuery.sql

	SELECT top 2000 execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery
	CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
	where execsql.text like '%textoparaprocurar%'
	ORDER BY execquery.last_execution_time DESC

RegisBarros / spaceused_all_tables_in_db.sql

Created October 10, 2017 01:01 — forked from rodolfofadino/spaceused_all_tables_in_db.sql

SpaceUsed All Tables

	SELECT
	o.name as 'TableName' ,
	SUM (
	CASE
	WHEN (index_id < 2) THEN row_count
	ELSE 0
	END
	) as 'RowCount',

	LTRIM (STR (SUM (reserved_page_count)/1024 * 8, 15, 0) + ' MB') as'Reserved MB',

RegisBarros / queryexecutioncount.sql

Created October 10, 2017 01:01 — forked from rodolfofadino/queryexecutioncount.sql

query execution count

	--DBCC TRACEON(8666)
	--GO

	SELECT qt.text [Comando],
	CP.usecounts [Qtd Executado],
	cp.size_in_bytes [TamanhoBytes],
	cp.objtype [TipoConsulta],
	qp.query_plan [ExecutionPlan]
	FROM sys.dm_exec_cached_plans cp
	CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp