marcelobrake

cd /usr/bin
wget http://www.vdberg.org/~richard/tcpping
chmod 755 tcpping

marcelobrake

FROM php:7.2-rc-zts-alpine

ARG APP_USER_USERNAME=app

RUN apk update && apk add --no-cache \
    sudo bash \
    g++ make autoconf \
    libxml2-dev icu-dev curl-dev pcre-dev

RUN adduser -D -s /bin/bash $APP_USER_USERNAME \

marcelobrake

SELECT sqltext.TEXT,  		
		DB_Name(req.database_id) AS BD,
       req.session_id,	   
	   req.user_id,
       req.status,
       req.command,
       req.cpu_time,
       req.total_elapsed_time,
	   req.logical_reads,	   
	   req.reads,

marcelobrake

SELECT getdate(), @@servername,  db_name(db_id()), object_name(B.Object_id), B.Name,  avg_fragmentation_in_percent,page_Count,fill_factor
FROM sys.dm_db_index_physical_stats(db_id(),null,null,null,null) A
join sys.indexes B on a.object_id = B.Object_id and A.index_id = B.index_id
WHERE avg_fragmentation_in_percent > 5 and page_count > 1000
ORDER BY page_count DESC, avg_fragmentation_in_percent DESC


--entre 5 e 30: reorganize
-- > 30: rebuild

marcelobrake

Colocar o projeto em c:\wamp\www\estoque_aula

Editar o arquivo c:\windows\system32\drivers\etc\hosts e mudar a linha:

192.168.56.2      estoque

para 

127.0.0.1       estoque