Tagged: SQL Server

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?w=1080&ssl=1 1080w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=300%2C300&ssl=1 300w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=1024%2C1024&ssl=1 1024w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=768%2C768&ssl=1 768w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=740%2C740&ssl=1 740w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?resize=50%2C50&ssl=1 50w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="104803" data-permalink="https://terminaldeinformacao.com/2023/03/22/como-gerar-o-plano-de-execucao-de-query-no-azure-data-studio/2-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?fit=1080%2C1080&ssl=1" data-orig-size="1080,1080" 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="2" data-image-description="" data-image-caption="<p>Plano de Execução</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?fit=300%2C300&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2022/11/2.png?fit=720%2C720&ssl=1" />

Como gerar o plano de execução de query no Azure Data Studio

No artigo de hoje, vamos demonstrar em como visualizar o plano de execução (execution plan) de uma query usando o Azure Data Studio (ADS).

22 de março de 2023

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="102949" data-permalink="https://terminaldeinformacao.com/2021/10/07/por-que-nao-e-indicado-usarmos-em-relacionamentos-no-sql-server/slide36-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?fit=1280%2C720&ssl=1" data-orig-size="1280,720" 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="Slide36" data-image-description="" data-image-caption="<p>Usar + em relacionamentos SQL</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide36.png?fit=720%2C405&ssl=1" />

Banco de Dados / TOTVS

Por que não é indicado usarmos + em relacionamentos no SQL Server

Hoje vou trazer uma dica para otimizar algumas queries SQL.

7 de outubro de 2021

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="102897" data-permalink="https://terminaldeinformacao.com/2021/09/15/como-usar-o-count-com-case-no-sql-server/slide34-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?fit=1280%2C720&ssl=1" data-orig-size="1280,720" 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="Slide34" data-image-description="" data-image-caption="<p>Count com Case</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide34.png?fit=720%2C405&ssl=1" />

Como usar o COUNT com CASE no SQL Server

No artigo de hoje, vou demonstrar como fazer um COUNT com CASE WHEN no SQL Server.

15 de setembro de 2021

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="102629" data-permalink="https://terminaldeinformacao.com/2021/08/11/exemplo-de-query-de-transferencia-de-estoque/slide16-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?fit=1280%2C720&ssl=1" data-orig-size="1280,720" 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="Slide16" data-image-description="" data-image-caption="<p>Query de Transferência de Estoque</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/04/Slide16.png?fit=720%2C405&ssl=1" />

Banco de Dados / TOTVS

Exemplo de Query de Transferência de Estoque

Hoje vou mostrar uma simples query, que serve para trazer os dados de entrada e saída de uma transferência do estoque.

11 de agosto de 2021

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="102857" data-permalink="https://terminaldeinformacao.com/2021/08/05/como-selecionar-todos-os-recnos-em-uma-query-com-group-by/slide53/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?fit=1280%2C720&ssl=1" data-orig-size="1280,720" 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="Slide53" data-image-description="" data-image-caption="<p>Como selecionar os Recnos em um GROUP BY</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/05/Slide53.jpg?fit=720%2C405&ssl=1" />

Banco de Dados / TOTVS

Como selecionar todos os RECNOs em uma query com GROUP BY

No artigo de hoje, vou demonstrar como selecionar informações em uma coluna de query usando FOR XML PATH.

5 de agosto de 2021

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" loading="lazy" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="103027" data-permalink="https://terminaldeinformacao.com/2021/06/22/como-ver-o-percentual-de-uma-operacao-no-sql-server/slide35-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?fit=1280%2C720&ssl=1" data-orig-size="1280,720" 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="Slide35" data-image-description="" data-image-caption="<p>Como ver o percentual de uma operação no SQL</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2021/06/Slide35.png?fit=720%2C405&ssl=1" />

Como ver o percentual de uma operação no SQL Server

No artigo de hoje vou mostrar como ver o percentual de uma operação no SQL Server via linha comandos em uma query.

22 de junho de 2021