Category: Banco de Dados

SQL Server

<img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" 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" />

Como resolver a mensagem de uso exclusivo numa database ao restaurar um backup no SQL Server

Você por acaso, ao restaurar uma database se encontrou com uma mensagem que impedia como prosseguir? Saiba como resolver.

11 de maio de 2019

SQL Server

<img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" 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" />

Como gerar o sp_who com filtros e ORDER BY

Você já precisou executar o sp_who no SQL Server para ver quem estava usando a base? E filtrar e ordernar esses dados, sabe como...

20 de abril de 2019

Banco de Dados / Tutoriais e Dicas

Como instalar e configurar o Azure Data Studio

Você sabia que a Microsoft lançou um novo “SQL Server Management Studio”? Saiba como instalar e configurar o Azure Data Studio (também tem para...

16 de fevereiro de 2019

SQL Server

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="SQL Server" decoding="async" loading="lazy" 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" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" 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" />

Como ativar o tema escuro no SQL Server

Olá pessoal… Hoje vou mostrar como ativar o tema dark no SQL Server Management Studio.

13 de fevereiro de 2019

SQL Server

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="SQL Server" decoding="async" loading="lazy" 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" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" 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" />

Função que retorna a diferença entre 2 dias e horas no SQL Server

Olá pessoal… Hoje vou mostrar uma função desenvolvida em SQL Server, que retorna a diferença entre duas datas em Dias, Horas, Minutos e Segundos.

31 de outubro de 2018

SQL Server

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="SQL Server" decoding="async" loading="lazy" 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" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" 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" />

Como alterar a Collation do SQL Server através de uma procedure

Olá pessoal… Hoje vou mostrar como alterar a Collation do SQL Server para todas as tabelas via script.

22 de agosto de 2018