Tagged: Banco de Dados

Postagens envolvendo BD, sendo estruturação, instalação e cláusulas SQL.

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

SQL Server

Como criar um backup automático do SQL Server

Olá pessoal… Hoje vou mostrar como fazer um backup automaticamente do SQL Server.

14 de março de 2018

<img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

SQL Server

Como pegar o número da semana via SQL Server

Olá pessoal… Hoje vou mostrar como pegar o número da semana utilizando funções do SQL Server.

7 de fevereiro de 2018

<img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

SQL Server

Como agendar um processo no SQL Server

Olá pessoal… Hoje vou mostrar como agendar um processo para ser executado todo dia no SQL Server.

1 de novembro de 2017

<img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

SQL Server

Como encerrar todas as conexões de uma DataBase no SQL Server

Olá pessoal… Hoje vou mostrar como encerrar todas as conexões em uma database no SQL Server.

11 de outubro de 2017

<img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

SQL Server

Consulta para ver o conteúdo de procedures

Olá pessoal… Hoje vou mostrar um script SQL que traz o conteúdo de todas as procedures do banco.

16 de agosto de 2017

<img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" data-sizes="(max-width: 200px) 100vw, 200px" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

SQL Server

Script para manutenção do SQL Server

Olá pessoal… Trago hoje um script de manutenção para o SQL Server, com intuito de otimizar o Banco de Dados.

2 de agosto de 2017