tag:blogger.com,1999:blog-63431663584894930852024-03-19T08:36:47.779-03:00Desenvolvedorltecno.com.brCláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comBlogger113125tag:blogger.com,1999:blog-6343166358489493085.post-21075752945085647632021-03-16T08:51:00.005-03:002021-03-16T08:51:49.936-03:00Comandos git do dia a diaĈ¿<div><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain" style="box-sizing: border-box;"><br /></span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain" style="box-sizing: border-box;">#Criando um projeto do zero</span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;"><pre style="background-color: #f6f8fa; border-radius: 6px; box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 13.6px; line-height: 1.45; margin-bottom: 16px; margin-top: 10px; overflow-wrap: normal; overflow: auto; padding: 16px;"><code class="hljs language-shell" style="background: transparent; border-radius: 6px; border: 0px; box-sizing: border-box; display: inline; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; line-height: inherit; margin: 0px; overflow-wrap: normal; overflow: visible; padding: 0px; word-break: normal;"><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;">echo "# UBBOAT_App" >> README.md</pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain" style="box-sizing: border-box;">git init</span>
<span class="user-select-contain" style="box-sizing: border-box;">git add README.md</span>
<span class="user-select-contain" style="box-sizing: border-box;">git commit -m "first commit"</span>
<span class="user-select-contain" style="box-sizing: border-box;">git branch -M main</span>
<span class="user-select-contain" style="box-sizing: border-box;">git remote add origin <span data-targets="git-clone-help.helpTexts" style="box-sizing: border-box;">https://github.com/seulogin/xxxxxx.git</span></span>
<span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;">git push -u origin main</span></pre></pre></code></pre></span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;"><br /></span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;"><br /></span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;">#Adicionado um projeto remoto na pasta local </span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><pre class="copyable-terminal-content f5" id="empty-setup-push-repo-echo" style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><br /></pre><pre class="copyable-terminal-content f5" id="empty-setup-push-repo-echo" style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain" style="box-sizing: border-box;"><pre style="background-color: #f6f8fa; border-radius: 6px; box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 13.6px; line-height: 1.45; margin-bottom: 16px; margin-top: 10px; overflow-wrap: normal; overflow: auto; padding: 16px;"><pre class="copyable-terminal-content f5" id="empty-setup-push-repo-echo" style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain" style="box-sizing: border-box;">git remote add origin <span data-targets="git-clone-help.helpTexts" style="box-sizing: border-box;">https://github.com/login/xxxxx.git</span></span>
<span class="user-select-contain" style="box-sizing: border-box;">git branch -M main</span>
<span class="user-select-contain" style="box-sizing: border-box;">git push -u origin main</span></pre></pre></span></pre></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;"><br /></span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;">Removendo pasta local do servidor remoto</span></pre><pre class="copyable-terminal-content f5" id="empty-setup-new-repo-echo" style="box-sizing: border-box; margin-bottom: 0px; margin-top: 0px; overflow: auto;"><span class="user-select-contain mb-0" style="box-sizing: border-box; margin-bottom: 0px !important;"><pre style="background-color: #f6f8fa; border-radius: 6px; box-sizing: border-box; line-height: 1.45; margin-bottom: 16px; margin-top: 10px; overflow-wrap: normal; overflow: auto; padding: 16px;"><code class="hljs language-shell" style="background: transparent; border-radius: 6px; border: 0px; box-sizing: border-box; display: inline; line-height: inherit; margin: 0px; overflow-wrap: normal; overflow: visible; padding: 0px; word-break: normal;"><span style="color: #24292e; font-family: SFMono-Regular, Consolas, Liberation Mono, Menlo, monospace;"><span style="font-size: 13.6px;">#lista os vinculados
git remote -v
#exemplo
origin https://github.com/login/xxxx-app.git (fetch)
origin https://github.com/login/xxxx-app.git (push)
#comando para remover
git remote rm origin
</span></span></code></pre></span></pre></pre></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-9392818264886511622021-02-21T00:39:00.002-03:002021-02-21T00:39:36.674-03:00react-select default value Ĉ¿<div>Abaixo exemplo em ReactJs para consumir uma API REST, alimentar um drolist e definir o valor default </div><div><br /></div><div>Exemplo de retorno da API https://localhost:44385/api/Tipos/</div><div><span style="white-space: pre-wrap;"><br /></span></div><div><span style="white-space: pre-wrap;">[{"id":1,"tP_Conta":"Débito"},{"id":2,"tP_Conta":"Crédito"}]</span></div><div><span style="white-space: pre-wrap;"><br /></span></div><div><div style="background-color: #151515; color: #999999; font-family: MonoLisa, Menlo, Monaco, "Courier New", monospace; font-size: 15px; line-height: 24px; white-space: pre;"><div><span style="color: #c678dd;">import</span> <span style="color: #e06c75;">React</span><span style="color: #abb2bf;">,</span> <span style="color: #abb2bf;">{</span> <span style="color: #e06c75;">Component</span> <span style="color: #abb2bf;">}</span> <span style="color: #c678dd;">from</span> <span style="color: #98c379;">"react"</span><span style="color: #abb2bf;">;</span></div><div><span style="color: #c678dd;">import</span> <span style="color: #e06c75;">Select</span> <span style="color: #c678dd;">from</span> <span style="color: #98c379;">'react-select'</span></div><div><span style="color: #c678dd;">import</span> <span style="color: #e06c75;">axios</span> <span style="color: #c678dd;">from</span> <span style="color: #98c379;">'axios'</span></div><br /><div><span style="color: #c678dd;">export</span><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">class</span><span style="color: #abb2bf;"> </span><span style="color: #e5c07b;">Tipo</span><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">extends</span><span style="color: #abb2bf;"> </span><span style="color: #98c379;">Component</span><span style="color: #abb2bf;"> {</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">constructor</span><span style="color: #abb2bf;">(props) {</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">super</span><span style="color: #abb2bf;">(props);</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">state</span><span style="color: #abb2bf;"> </span><span style="color: #56b6c2;">=</span><span style="color: #abb2bf;"> { title</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> </span><span style="color: #98c379;">""</span><span style="color: #abb2bf;">, loading</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> </span><span style="color: #d19a66;">true</span><span style="color: #abb2bf;">, selectOptions</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> []};</span></div><br /><div><span style="color: #abb2bf;"> }</span></div><br /><div><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">async</span><span style="color: #abb2bf;"> </span><span style="color: #61afef;">getOptions</span><span style="color: #abb2bf;">() {</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">const</span><span style="color: #abb2bf;"> </span><span style="color: #d19a66;">res</span><span style="color: #abb2bf;"> </span><span style="color: #56b6c2;">=</span><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">await</span><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">axios</span><span style="color: #abb2bf;">.</span><span style="color: #61afef;">get</span><span style="color: #abb2bf;">(</span><span style="color: #98c379;">'/api/Tipos'</span><span style="color: #abb2bf;">) </span><span style="color: #5c6370; font-style: italic;">//[{"id":1,"tP_Conta":"Débito"},{"id":2,"tP_Conta":"Crédito"}]</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">const</span><span style="color: #abb2bf;"> </span><span style="color: #d19a66;">data</span><span style="color: #abb2bf;"> </span><span style="color: #56b6c2;">=</span><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">res</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">data</span></div><br /><div><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">const</span><span style="color: #abb2bf;"> </span><span style="color: #d19a66;">options</span><span style="color: #abb2bf;"> </span><span style="color: #56b6c2;">=</span><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">data</span><span style="color: #abb2bf;">.</span><span style="color: #61afef;">map</span><span style="color: #abb2bf;">(d </span><span style="color: #c678dd;">=></span><span style="color: #abb2bf;"> ({</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #98c379;">"value"</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">d</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">id</span><span style="color: #abb2bf;">,</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #98c379;">"label"</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">d</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">tP_Conta</span></div><div><span style="color: #abb2bf;"> }))</span></div><br /><div><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">.</span><span style="color: #61afef;">setState</span><span style="color: #abb2bf;">({ selectOptions</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> options })</span></div><br /><div><span style="color: #abb2bf;"> }</span></div><br /><div><span style="color: #abb2bf;"> </span><span style="color: #61afef;">componentDidMount</span><span style="color: #abb2bf;">() {</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">.</span><span style="color: #61afef;">getOptions</span><span style="color: #abb2bf;">()</span></div><div><span style="color: #abb2bf;"> }</span></div><br /><div><span style="color: #abb2bf;"> </span><span style="color: #61afef;">render</span><span style="color: #abb2bf;">() {</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #e5c07b;">console</span><span style="color: #abb2bf;">.</span><span style="color: #56b6c2;">log</span><span style="color: #abb2bf;">(</span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">state</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">selectOptions</span><span style="color: #abb2bf;">)</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #c678dd;">return</span><span style="color: #abb2bf;"> (</span></div><div><span style="color: #abb2bf;"> </span><span style="color: #abb2bf;"><</span><span style="color: #e06c75;">div</span><span style="color: #abb2bf;">></span></div><div><span style="color: #abb2bf;"> <</span><span style="color: #e5c07b;">Select</span><span style="color: #abb2bf;"> </span><span style="color: #d19a66;">options</span><span style="color: #abb2bf;">={</span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">state</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">selectOptions</span><span style="color: #abb2bf;">} </span><span style="color: #d19a66;">onChange</span><span style="color: #abb2bf;">={</span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">.</span><span style="color: #e06c75;">handleChange</span><span style="color: #abb2bf;">.</span><span style="color: #61afef;">bind</span><span style="color: #abb2bf;">(</span><span style="color: #e06c75;">this</span><span style="color: #abb2bf;">)} </span><span style="color: #d19a66;">defaultValue</span><span style="color: #abb2bf;">={{ label</span><span style="color: #56b6c2;">:</span><span style="color: #abb2bf;"> </span><span style="color: #98c379;">"Débito"</span><span style="color: #abb2bf;">, value</span><span style="color: #56b6c2;">:</span><span style="color: #98c379;">" 1"</span><span style="color: #abb2bf;">}}</span><span style="color: #abb2bf;">/> </span></div><div><span style="color: #abb2bf;"> </</span><span style="color: #e06c75;">div</span><span style="color: #abb2bf;">></span></div><br /><br /><div><span style="color: #abb2bf;"> )</span></div><div><span style="color: #abb2bf;"> }</span></div><br /><div><span style="color: #abb2bf;">}</span></div></div></div><div><span style="white-space: pre-wrap;"><br /></span></div><div><br /></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-23221266611368067002021-02-13T00:10:00.001-03:002021-02-13T00:10:28.854-03:00Google Maps SDK for iOS crashes if CFBundleExecutable contains non-English charactersĈ¿ Ao compilar meu projeto no Xcode, apresentou o erro abaixo? <div><br /></div><div><h3 class="text-black ng-binding" style="background-color: white; box-sizing: border-box; font-family: Montserrat; font-size: 24px; line-height: 1.1; margin-bottom: 10px; margin-top: 20px; word-break: break-word;">Google Maps SDK for iOS crashes if CFBundleExecutable contains non-English characters</h3></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGl6qDLG0o53DvC_JrMiQGlYVgmJZBUYXMPIgMpM81TNv3eXYLmXYVY-kLuP9FkEHb4E4G-z2NX8ESRY6hVyliSYkmFzZKNps4NqfkoiWn2yTKkCu53hMeJ8C4S7lhQt9YPs1om_tMJd4/s2532/Simulator+Screen+Shot+-+iPhone+12+-+2021-02-12+at+20.43.26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="2532" data-original-width="1170" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGl6qDLG0o53DvC_JrMiQGlYVgmJZBUYXMPIgMpM81TNv3eXYLmXYVY-kLuP9FkEHb4E4G-z2NX8ESRY6hVyliSYkmFzZKNps4NqfkoiWn2yTKkCu53hMeJ8C4S7lhQt9YPs1om_tMJd4/s320/Simulator+Screen+Shot+-+iPhone+12+-+2021-02-12+at+20.43.26.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Existe duas opções para corrigir o problema no <b>config.xml</b></div><div>Alterando a tag <span style="color: grey; font-family: Menlo, Monaco, Courier New, monospace;"><span style="font-size: 12px; white-space: pre;"> </span></span></div><div><span style="color: grey; font-family: Menlo, Monaco, "Courier New", monospace; font-size: 12px; white-space: pre;"><br /></span></div><div><div style="background-color: #1e1e1e; color: #d4d4d4; font-family: Menlo, Monaco, "Courier New", monospace; font-size: 12px; line-height: 18px; white-space: pre;"> <span style="color: grey;"><</span><span style="color: #569cd6;">name</span><span style="color: grey;">></span>Usar nome sem acentos<span style="color: grey;"></</span><span style="color: #569cd6;">name</span><span style="color: grey;">></span></div></div><div><br /></div>Ou usando tag de nome curto<div><div style="background-color: #1e1e1e; color: #d4d4d4; font-family: Menlo, Monaco, "Courier New", monospace; font-size: 12px; line-height: 18px; white-space: pre;"> <span style="color: grey;"><</span><span style="color: #569cd6;">name</span> <span style="color: #9cdcfe;">short</span>=<span style="color: #ce9178;">"(non-english app name)"</span><span style="color: grey;">></span>(english app name)<span style="color: grey;"></</span><span style="color: #569cd6;">name</span><span style="color: grey;">></span></div><div><br /></div></div><div>Após isso remova e adicione a plataforma novamente </div><div><br /></div><div>cordova platform rm ios </div><div><br /></div><div>cordova platform add ios </div><div><br /></div><div>Feito :D </div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3D83Gra0gGolG5anxJc1PTV5_ZlNaZ4e3SiemjyJCEK5HyyFy8hr_TNwnOifWJaKHs-8kyM975drf0GxJt9znmVjP9eWVEQz89HWosVqCREQU0ZMs44v0mHeazYncscr8qzWBoiwIIxU/s2532/Simulator+Screen+Shot+-+iPhone+12+-+2021-02-13+at+00.09.36.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="2532" data-original-width="1170" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3D83Gra0gGolG5anxJc1PTV5_ZlNaZ4e3SiemjyJCEK5HyyFy8hr_TNwnOifWJaKHs-8kyM975drf0GxJt9znmVjP9eWVEQz89HWosVqCREQU0ZMs44v0mHeazYncscr8qzWBoiwIIxU/s320/Simulator+Screen+Shot+-+iPhone+12+-+2021-02-13+at+00.09.36.png" /></a></div><br /><div><br /></div><div><br /></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-51695547114388050892021-02-12T23:50:00.000-03:002021-02-12T23:50:00.865-03:00Erro ao adicionar a plataforma IOS IONICĈ¿ cordova platform add ios<div>Error: npm: Command failed with exit code 1 Error output:</div><div>npm ERR! code ENOLOCAL</div><div>npm ERR! Could not install from "ios" as it does not contain a package.json file.</div><div><br /></div><div>Pode ser que tenha utilizado o Capacitor, e precisa excluir a IOS na raiz do projeto</div><div><br /></div><div><br /></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-91980975611285702202021-02-10T11:46:00.000-03:002021-02-10T11:46:00.601-03:00Encontrar o tamanho das colunas da tabela SQL SERVERĈ¿<div><br /></div><div><pre class="lang-sql s-code-block hljs" style="border-radius: 5px; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.30769; margin-bottom: 0px; margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: 12px; vertical-align: baseline; width: auto;"><code style="border: 0px; box-sizing: inherit; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span> cNmColuna = C.name
,cTpColuna = <span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">UPPER</span>(TYPE_NAME(C.user_type_id))
,iMaxDigit = <span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">CASE</span>
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">WHEN</span> T.precision = <span class="hljs-number" style="border: 0px; box-sizing: inherit; color: var(--highlight-namespace); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">0</span>
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">THEN</span> C.max_length
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">ELSE</span> T.precision
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">END</span>
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">FROM</span> sys.all_columns C <span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">WITH</span>(NOLOCK)
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">INNER</span> <span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">JOIN</span> sys.types T <span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">WITH</span>(NOLOCK) <span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">ON</span> T.user_type_id = C.user_type_id
<span class="hljs-keyword" style="border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">WHERE</span> C.object_id = Object_Id(<span class="hljs-string" style="border: 0px; box-sizing: inherit; color: var(--highlight-variable); font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">'Nome da Tabela'</span>)</code></pre><pre class="lang-sql s-code-block hljs" style="border-radius: 5px; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.30769; margin-bottom: 0px; margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: 12px; vertical-align: baseline; width: auto;"><code style="border: 0px; box-sizing: inherit; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><br /></code></pre><pre class="lang-sql s-code-block hljs" style="border-radius: 5px; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.30769; margin-bottom: 0px; margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: 12px; vertical-align: baseline; width: auto;"><code style="border: 0px; box-sizing: inherit; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><br /></code></pre><pre class="lang-sql s-code-block hljs" style="border-radius: 5px; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.30769; margin-bottom: 0px; margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: 12px; vertical-align: baseline; width: auto;"><code style="border: 0px; box-sizing: inherit; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><br /></code></pre><pre class="lang-sql s-code-block hljs" style="border-radius: 5px; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.30769; margin-bottom: 0px; margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: 12px; vertical-align: baseline; width: auto;"><code style="border: 0px; box-sizing: inherit; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;">Ref: https://pt.stackoverflow.com/questions/12549/como-pegar-o-tamanho-total-de-caracteres-de-uma-coluna-sql</code></pre></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-32247182463636643112020-12-08T16:27:00.001-03:002020-12-08T16:27:01.588-03:00DeadLock listar as sessões ocorrendo no banco SQL ServerĈ¿ <div><br /></div><div>Para listar os deadlocks di log , execute o comando abaixo</div><div><br /></div><div><table class="crayon-table" style="background-attachment: initial !important; background-clip: initial !important; background-color: white; background-image: initial !important; background-origin: initial !important; background-position: 0px 0px !important; background-repeat: initial !important; background-size: initial !important; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; color: #555555; font-family: Monaco, monacoregular, "courier new", monospace; font-size: 14px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 0px !important; margin-left: 0px; margin-right: 0px !important; margin-top: 0px !important; padding: 0px !important; table-layout: auto !important; text-align: center; vertical-align: baseline; width: auto !important;"><tbody style="border: 0px; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><tr class="urvanov-syntax-highlighter-row" style="background: 0px center; border: none !important; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px !important; padding: 0px !important; vertical-align: top !important;"><td class="crayon-nums" data-settings="show" style="background: rgb(223, 239, 255) !important; border: none !important; color: rgb(84, 153, 222) !important; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px !important; padding: 0px !important; vertical-align: top !important;"><div class="urvanov-syntax-highlighter-nums-content swift-in-viewport" style="background: 0px center; border: 0px; font-size: 12px !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 15px !important; margin: 0px; padding: 0px; text-align: left; vertical-align: baseline; white-space: nowrap;"><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-4" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;"><br class="Apple-interchange-newline" />4</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-5" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">5</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-6" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">6</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-7" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">7</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-8" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">8</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-9" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">9</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-10" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">10</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-11" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">11</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-12" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">12</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-13" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">13</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-14" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">14</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-15" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">15</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-16" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">16</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-17" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">17</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-18" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">18</div><div class="crayon-num swift-in-viewport" data-line="urvanov-syntax-highlighter-5fc4133ee3177986607991-19" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; text-align: center; vertical-align: baseline;">19</div></div></td><td class="urvanov-syntax-highlighter-code" style="background: 0px center; border: none !important; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px !important; padding: 0px !important; vertical-align: top !important; width: 752px;"><div class="crayon-pre swift-in-viewport" style="background: 0px 0px !important; border: none !important; color: black; font-size: 12px !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 15px !important; margin: 0px; overflow: visible; padding: 0px; tab-size: 4; text-align: left; vertical-align: baseline; white-space: pre;"><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-1" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">DECLARE</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">TimeZone</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">INT</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-o" style="background-image: none !important; border: 0px; color: gray !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">DATEDIFF</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">HOUR</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">GETUTCDATE</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">GETDATE</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-2" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"> </div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-3" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-4" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">DATEADD</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">HOUR</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">TimeZone</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">xed</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">value</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-s" style="background-image: none !important; border: 0px; color: red !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'@timestamp'</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-s" style="background-image: none !important; border: 0px; color: red !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'datetime2(3)'</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">CreationDate</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-5" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">xed</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">query</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-s" style="background-image: none !important; border: 0px; color: red !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'.'</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">XEvent</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-6" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">FROM</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-7" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-8" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-9" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">CAST</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">st</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">[</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">target_data</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">]</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">XML</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">TargetData</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-10" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">FROM</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-11" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">sys</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">dm_xe_session_targets</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">st</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-12" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">INNER</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">JOIN</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">sys</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">dm_xe_sessions</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">s</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">ON</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">s</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">[</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">address</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">]</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-o" style="background-image: none !important; border: 0px; color: gray !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">st</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">event_session_address</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-13" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-14" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">s</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">[</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">name</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">]</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-o" style="background-image: none !important; border: 0px; color: gray !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">N</span><span class="crayon-s" style="background-image: none !important; border: 0px; color: red !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'system_health'</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-15" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AND</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">st</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">target_name</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-o" style="background-image: none !important; border: 0px; color: gray !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">N</span><span class="crayon-s" style="background-image: none !important; border: 0px; color: red !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'ring_buffer'</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-16" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">[</span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">Data</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">]</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-17" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">CROSS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">APPLY</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">TargetData</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">nodes</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-s" style="background-image: none !important; border: 0px; color: red !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'RingBufferTarget/event[@name="xml_deadlock_report"]'</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">AS</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="background-image: none !important; border: 0px; color: rgb(255, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">XEventData </span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">xed</span><span class="crayon-sy" style="background-image: none !important; border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-18" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">ORDER</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">BY</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></div><div class="crayon-line swift-in-viewport" id="urvanov-syntax-highlighter-5fc4133ee3177986607991-19" style="background: 0px center; border: 0px; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;"><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-i" style="background-image: none !important; border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">CreationDate</span><span class="crayon-h" style="background-image: none !important; border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-k" style="background-image: none !important; border: 0px; color: rgb(0, 0, 255) !important; font-family: inherit; font-size: inherit !important; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">DESC</span></div></div></td></tr></tbody></table><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div>fonte: https://www.dirceuresende.com/blog/sql-server-como-gerar-um-monitoramento-de-historico-de-deadlocks-para-analise-de-falhas-em-rotinas/</div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-70790910718651454032020-12-03T19:44:00.000-03:002020-12-03T19:44:00.943-03:00Índices (index) faltante no MSSQLĈ¿ <span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;">Descobrir índices faltantes no servidor de banco de dados SQL SERVER</span><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><br /></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;">O SQL Server armazena uma sugestão de índices que devem ser criados/analisados e que ajudarão a melhorar o desempenho das consultas. </span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;">Segue script para listar todos, sugestão depois de criar um, atualize a consulta</span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><div class="line number1 index0 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">SELECT</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">sys.objects.</code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">name</code></div><div class="line number2 index1 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">, (avg_total_user_cost * avg_user_impact) * (user_seeks + user_scans) </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AS</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">Impact</code></div><div class="line number3 index2 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">, </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">'CREATE NONCLUSTERED INDEX ix_IndexName ON '</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ sys.objects.</code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">name</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">COLLATE</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">DATABASE_DEFAULT + </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">' ( '</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ </code><code class="sql color2" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(255, 20, 147) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">IsNull</code><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">(mid.equality_columns, </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">''</code><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">) + </code><code class="sql color2" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(255, 20, 147) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">CASE</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">WHEN</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mid.inequality_columns </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">IS</code> <code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">NULL</code></div><div class="line number4 index3 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">THEN</code> <code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">''</code> </div><div class="line number5 index4 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ELSE</code> <code class="sql color2" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(255, 20, 147) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">CASE</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">WHEN</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mid.equality_columns </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">IS</code> <code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">NULL</code></div><div class="line number6 index5 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">THEN</code> <code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">''</code> </div><div class="line number7 index6 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ELSE</code> <code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">','</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">END</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ mid.inequality_columns </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">END</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">' ) '</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ </code><code class="sql color2" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(255, 20, 147) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">CASE</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">WHEN</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mid.included_columns </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">IS</code> <code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">NULL</code></div><div class="line number8 index7 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">THEN</code> <code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">''</code> </div><div class="line number9 index8 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ELSE</code> <code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">'INCLUDE ('</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ mid.included_columns + </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">')'</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">END</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">+ </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">';'</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AS</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">CreateIndexStatement</code></div><div class="line number10 index9 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">, mid.equality_columns</code></div><div class="line number11 index10 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">, mid.inequality_columns</code></div><div class="line number12 index11 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">, mid.included_columns </code></div><div class="line number13 index12 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">FROM</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">sys.dm_db_missing_index_group_stats </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AS</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">migs </code></div><div class="line number14 index13 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">INNER</code> <code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">JOIN</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">sys.dm_db_missing_index_groups </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AS</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mig </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ON</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">migs.group_handle = mig.index_group_handle </code></div><div class="line number15 index14 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">INNER</code> <code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">JOIN</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">sys.dm_db_missing_index_details </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AS</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mid </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ON</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mig.index_handle = mid.index_handle </code><code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AND</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mid.database_id = DB_ID() </code></div><div class="line number16 index15 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">INNER</code> <code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">JOIN</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">sys.objects </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">WITH</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">(nolock) </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ON</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">mid.OBJECT_ID = sys.objects.OBJECT_ID </code></div><div class="line number17 index16 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">WHERE</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">(migs.group_handle </code><code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">IN</code></div><div class="line number18 index17 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">( </code></div><div class="line number19 index18 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">SELECT</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">TOP</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">(500) group_handle </code></div><div class="line number20 index19 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">FROM</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">sys.dm_db_missing_index_group_stats </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">WITH</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">(nolock) </code></div><div class="line number21 index20 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ORDER</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">BY</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">(avg_total_user_cost * avg_user_impact) * (user_seeks + user_scans) </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">DESC</code><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">)) </code></div><div class="line number22 index21 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql color1" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: gray !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">AND</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">OBJECTPROPERTY(sys.objects.OBJECT_ID, </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">'isusertable'</code><code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">)=1 </code></div><div class="line number23 index22 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-weight: 400; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;"><code class="sql spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">ORDER</code> <code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">BY</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">2 </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">DESC</code> <code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">, 3 </code><code class="sql keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; box-shadow: none !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; inset: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; vertical-align: baseline !important; width: auto !important;">DESC</code></div></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;"><br /></span></span></div><div><span style="background-color: white; box-sizing: inherit; color: #424143; font-family: "Open Sans", Helvetica, Arial, sans-serif; font-size: 14px; font-weight: 700;"><span style="font-weight: 400;">Fonte: </span></span><span style="color: #424143; font-family: Open Sans, Helvetica, Arial, sans-serif;"><span style="font-size: 14px;">https://dbasqlserverbr.com.br/top-10-scripts-de-indices-que-todos-dbas-precisam-saber-sql-server/</span></span></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-58389107703668203462020-12-02T23:20:00.001-03:002020-12-02T23:20:10.752-03:00Formatar Query MSSQLĈ¿<div>Uma ótima ferramenta para formatar os SQL é essa <a href="https://sql-format.com/" target="_blank">https://sql-format.com/ </a></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRHttKnKvWXGbGIFZWFr1OJoQ7Z8QfB2rFrj4ZbMWACNnjPq727y7VDaQ3brHnSyJYwctwudJmvZ8oxMoy2jY_ddY0IOopMQrox-eeInNc0i-xGQHP62wZLncmEz4mKELCGehx9hT2A54/s1104/format+sql.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="595" data-original-width="1104" height="344" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRHttKnKvWXGbGIFZWFr1OJoQ7Z8QfB2rFrj4ZbMWACNnjPq727y7VDaQ3brHnSyJYwctwudJmvZ8oxMoy2jY_ddY0IOopMQrox-eeInNc0i-xGQHP62wZLncmEz4mKELCGehx9hT2A54/w640-h344/format+sql.PNG" width="640" /></a></div><br /><div><br /></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-53015152601324070192020-12-01T23:33:00.002-03:002020-12-01T23:33:37.779-03:00Identificar quantidade de registro por tabela MSSQLĈ¿<div><br /></div><div><br /></div><div>Dentro da janela de consulta do SQL SERVER basta rodar o comando abaixo</div><div><br /></div><div><span> </span>CREATE TABLE #TMP_CONTA_TABELA</div><div> (TABELA VARCHAR(200),</div><div> REGISTRO INT)</div><div><br /></div><div> DECLARE @COMANDO VARCHAR(500)</div><div> DECLARE C_CountTable CURSOR FAST_FORWARD FOR</div><div> SELECT distinct</div><div> 'SELECT TABELA = ''' + SU.NAME + '.' + SO.NAME + '''</div><div> , REGISTRO = COUNT(*) FROM ' + SU.NAME + '.' + SO.NAME</div><div> FROM SYSOBJECTS SO INNER JOIN SYSUSERS SU</div><div> ON SO.UID = SU.UID</div><div> AND SO.XTYPE = 'U'</div><div> AND SO.NAME <> 'dtproperties'</div><div> OPEN C_CountTable</div><div> FETCH NEXT FROM C_CountTable</div><div> INTO @COMANDO</div><div> WHILE @@FETCH_STATUS = 0</div><div> BEGIN</div><div> EXECUTE ('INSERT INTO #TMP_CONTA_TABELA '+ @COMANDO)</div><div> FETCH NEXT FROM C_CountTable</div><div> INTO @COMANDO</div><div> END</div><div> CLOSE C_CountTable</div><div> DEALLOCATE C_CountTable</div><div><br /></div><div> SELECT * from #TMP_CONTA_TABELA ORDER BY 2 DESC</div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div>fonte: https://www.devmedia.com.br/quantos-registros-existem-sua-tabela-no-sql-server/5345 </div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-79449362446968176042020-09-04T12:17:00.001-03:002020-09-04T12:17:14.013-03:00latin x utf8, resolvido essa loucura de problema com banco e conteúdo Ĉ¿ Recentemente fiz atualização de uma plataforma eletrônica de revista, normalmente conhecida como SEER ou OJS<div><br /></div><div>Meu banco mysql com charset em Latin1, e o conteúdo estava em Utf8.</div><div><br /></div><div>Depois de algumas pesquisas e teste, consegui converter o conteúdo com o exemplo do sql abaixo;</div><div><br /></div><div><div>UPDATE <b>TABELA_XYZ </b>SET <b>COLUNA_W </b>= </div><div> CONVERT(BINARY CONVERT(<b>COLUNA_W </b>USING latin1) USING utf8);</div></div><div><br /></div><div><br /></div>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-494465921854852812020-04-01T09:21:00.004-03:002020-04-01T09:21:47.285-03:00PESQUISAR TABELA NO BANCO DE DADOS SQL SERVERĈ¿<br />
<br />
<span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">-- Iniciando a pesquisa nas tabelas de sistemas</span><span class="c-mrkdwn__br" data-stringify-type="paragraph-break" style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; display: block; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures; height: 8px;"></span><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">SELECT A.NAME, A.TYPE, B.TEXT</span><br style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;" /><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">FROM SYSOBJECTS A (nolock)</span><br style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;" /><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">JOIN SYSCOMMENTS B (nolock)</span><br style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;" /><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">ON A.ID = B.ID</span><br style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;" /><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">WHERE B.TEXT LIKE '%TB_XYZ%' --- Informação a ser procurada no corpo da procedure, funcao ou view</span><br style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;" /><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">AND A.TYPE = 'P' --- Tipo de objeto a ser localizado no caso procedure</span><br style="background-color: #f8f8f8; box-sizing: inherit; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;" /><span style="background-color: #f8f8f8; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures;">ORDER BY A.NAME</span>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-59328123299197137482020-02-27T10:17:00.002-03:002020-02-27T14:59:53.012-03:00Desalocar memória MSSQLĈ¿<br />
<br />
Use apenas se conhecer os comandos, abaixo coloco as referências<br />
<br />
<pre lang="x-sql" style="background-color: white; border: none; color: #333333; direction: ltr; font-family: inherit; font-size: 14px; list-style-type: none; outline: 0px; overflow-wrap: break-word; padding: 0px;">DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE</pre>
<pre lang="x-sql" style="background-color: white; border: none; color: #333333; direction: ltr; font-family: inherit; font-size: 14px; list-style-type: none; outline: 0px; overflow-wrap: break-word; padding: 0px;"></pre>
<pre lang="x-sql" style="background-color: white; border: none; color: #333333; direction: ltr; font-family: inherit; font-size: 14px; list-style-type: none; outline: 0px; overflow-wrap: break-word; padding: 0px;"></pre>
<pre lang="x-sql" style="background-color: white; border: none; color: #333333; direction: ltr; font-family: inherit; font-size: 14px; list-style-type: none; outline: 0px; overflow-wrap: break-word; padding: 0px;"></pre>
<pre lang="x-sql" style="background-color: white; border: none; color: #333333; direction: ltr; font-family: inherit; font-size: 14px; list-style-type: none; outline: 0px; overflow-wrap: break-word; padding: 0px;"><a href="https://docs.microsoft.com/pt-br/sql/t-sql/database-console-commands/dbcc-dropcleanbuffers-transact-sql?view=sql-server-ver15">Ref. DBCC DROPCLEANBUFFERS</a></pre>
<pre lang="x-sql" style="background-color: white; border: none; color: #333333; direction: ltr; font-family: inherit; font-size: 14px; list-style-type: none; outline: 0px; overflow-wrap: break-word; padding: 0px;"><a href="https://docs.microsoft.com/pt-br/sql/t-sql/database-console-commands/dbcc-freeproccache-transact-sql?view=sql-server-ver15">Ref. DBCC FREEPROCCACHE</a></pre>
Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-92073422573617472212019-09-15T01:56:00.001-03:002019-09-15T01:56:26.290-03:00Atualização OJS 3.0.0. para OJS Version 3.1.2.1Ĉ¿<br />
<br />
Para atualizar esse sistema de revista eletrônica sugiro iniciar criando uma cópia do banco de dados e pasta, depois acesse e verifique está abrindo normalmente "não esqueça de alterar o config.inc.php para o banco novo"<br />
<br />
Alterações que deve realizar dentro do config.inc.php após concluir a instalação<br />
base_url<br />
Database Settings<br />
Captcha Settings<br />
Email Settings<br />
<br />
Se ocorrer erro 500, verifique<br />
versão do PHP que deve ser 7.0<br />
driver de conexão em Database Settings que deve ser mssqli<br />
<br />
Quando mandar atualizar e demorar para mostrar a mensagem de confirmação, experimente de alterar manualmente o config.inc.php para installed = On<br />
<br />
<br />Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-60265717569999186572019-09-05T10:22:00.000-03:002019-09-05T10:22:44.835-03:00TIME PARA FLOAT | FLOAT PARA TIME - MSSQLĈ¿<br />
<br />
Como converter horário em FLOAT e retornar para horário no SQL SERVER<br />
<br />
Exemplo realizado no Excel<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjg9ceMKXogrnpb7vuziYNAwoslU0KpSbx6sjbVnCToay5qyAMxhNnqZ87iY24Vr0k_KVDxVkIcUxrD3LFj5bThTcgCylUKJ4EaDbrAzbENDW3xwOOBbJJDGICFBgSY0Ntz0gYVtY3BR0s/s1600/Capturar.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="89" data-original-width="342" height="83" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjg9ceMKXogrnpb7vuziYNAwoslU0KpSbx6sjbVnCToay5qyAMxhNnqZ87iY24Vr0k_KVDxVkIcUxrD3LFj5bThTcgCylUKJ4EaDbrAzbENDW3xwOOBbJJDGICFBgSY0Ntz0gYVtY3BR0s/s320/Capturar.PNG" width="320" /></a></div>
<br />
Declare @data As time = '10:00:00.0000000'<br />
,@H As Float<br />
,@M As Float<br />
,@S As Bigint<br />
,@Result As Float<br />
<br />
Set @H = Datepart(hh,@data)*3600<br />
Set @M = Datepart(mi,@data)*60<br />
Set @s = Datepart(ss,@data)<br />
<br />
Set @Result = (@H + @M + @s) / 86400<br />
<br />
Select CONVERT(TIME,cast(@Result as DateTime)) TIME, @Result FLOAT<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjShiM2Hd1iE9h8aMqolJH45XzjP3EiCa5UcBQ7-8ACBCzhfJGezxh41nHAVvpDrZw3DwNd6TFiqKnsuvlj2CyY-oTF5toPGXGTGuwB0o2w9k7Q3a8fKd1pxMfjRV11H4GVXvARxERw_eI/s1600/Capturar2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="466" data-original-width="744" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjShiM2Hd1iE9h8aMqolJH45XzjP3EiCa5UcBQ7-8ACBCzhfJGezxh41nHAVvpDrZw3DwNd6TFiqKnsuvlj2CyY-oTF5toPGXGTGuwB0o2w9k7Q3a8fKd1pxMfjRV11H4GVXvARxERw_eI/s640/Capturar2.PNG" width="640" /></a></div>
<br />Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-17891526177150204882018-11-28T17:19:00.000-02:002018-11-28T17:19:14.750-02:00Git failed with a fatal error. Authentication failedĈ¿<br />
<br />
Ao tentar realizar clone de um projeto no Visual Studio e acontecer o erro abaixo, normalmente ocorre quando atualiza a senha do windows e o Git esta vinculado com este usuário.<br />
<br />
Erro encontrado durante a clonagem do repositório remoto: Git failed with a fatal error. Authentication failed for<br />
<br />
Acesse Painel de Controle > Contas de Usuários > Gerenciador de Credenciais<br />
<br />
Encontre a credencia e edite o usuário e senha.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiah47O4he8UBRmZyNkv0mivxWwT-fxzARkdx-qhfkJ_P1gcLcu6GRbH1HqSk8lH6XVJYdBa9hXlC0XJWul3j4VKPjVNtsgOuAg9rvBtRv7Zh7ZY0vQxQlKq8dbNSjZogDZCnJYq4FS3vU/s1600/Sem+t%25C3%25ADtulo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="898" data-original-width="1444" height="395" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiah47O4he8UBRmZyNkv0mivxWwT-fxzARkdx-qhfkJ_P1gcLcu6GRbH1HqSk8lH6XVJYdBa9hXlC0XJWul3j4VKPjVNtsgOuAg9rvBtRv7Zh7ZY0vQxQlKq8dbNSjZogDZCnJYq4FS3vU/s640/Sem+t%25C3%25ADtulo.png" width="640" /></a></div>
<br />Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-65656115747170955192018-08-25T16:24:00.002-03:002018-08-25T16:33:15.934-03:00Datetime? ToString("dd/MM/yyyy") MVC Ĉ¿<br />
<br />
<br />
Quando uma variável é do tipo data e aceita nulo, se tentar apenas colocar ToString("dd/MM/yyyy"), apresenta erro.<br />
<br />
Consegui resolver da seguinte forma:<br />
<br />
<span style="color: blue;"> @if (item.dtVencimento.HasValue)</span><br />
<span style="color: blue;"> { @item.dtVencimento.GetValueOrDefault(DateTime.Now).ToString("dd/MM/yyyy")</span><br />
<span style="color: blue;"> }</span>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-55013027094234951762018-08-25T13:13:00.003-03:002018-08-25T13:13:51.022-03:00Força table HTML full width ou fullscreenĈ¿<br />
<br />
Para deixar a tabela HTML cheia na tela, use o comando abaixo:<br />
<br />
table {<br />
margin: auto;<br />
width: calc(100% - 40px);<br />
}Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-53175564746921143612018-08-25T13:11:00.000-03:002018-08-25T13:11:05.093-03:00Forçar cores do CSS na impressão Ĉ¿<br />
<br />
Se quando for imprimir uma pagina e não carrega as cores do CSS, basta adicionar o script abaixo:<br />
<br />
body {<br />
-webkit-print-color-adjust: exact;<br />
}Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-29976866613097670492018-07-31T16:48:00.003-03:002018-07-31T16:48:49.276-03:00Mostrar valores da expressão com condicional no QlikviewĈ¿<br />
<br />
No objeto do qlikview ao habilitar o condicional, por exemplo mostrar os dados apenas após a seleção de um campo especifico.<br />
<br />
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;">=getselectedcount(NOMEDOCAMPO) >=1</span><br />
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 13px;">Ref: </span><span style="color: #444444; font-family: Roboto, Helvetica, Arial, sans-serif; font-size: 13px;">https://goo.gl/3py2Cg</span>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-10336406776774209292018-07-30T16:36:00.001-03:002018-07-30T16:36:29.196-03:00IBM Storage DS3512 - Reset senhaĈ¿<br />
<br />
Caso precise acessar o store e não tenha a senha, o procedimento abaixo lhe permite resetar a senha.<br />
<br />
Acessando via Telnet, através do Putty por exemplo.<br />
<br />
<table border="0" cellpadding="0" cellspacing="0" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-collapse: collapse; border-radius: 0px !important; border-spacing: 0px; border: 1px solid rgb(231, 231, 231); bottom: auto !important; box-sizing: content-box !important; color: #333333; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 16px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px -1px 24px 0px; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: 640px;"><tbody style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">
<tr style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><td class="gutter" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-bottom: 0px !important; border-image: initial !important; border-left: 0px !important; border-radius: 0px !important; border-right: 0px !important; border-top: 1px solid rgb(231, 231, 231); bottom: auto !important; box-sizing: content-box !important; color: rgb(175, 175, 175) !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 6px 24px; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><div class="line number1 index0 alt2" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
1</div>
<div class="line number2 index1 alt1" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
2</div>
<div class="line number3 index2 alt2" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
3</div>
<div class="line number4 index3 alt1" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
4</div>
<div class="line number5 index4 alt2" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
5</div>
<div class="line number6 index5 alt1" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
6</div>
<div class="line number7 index6 alt2" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
7</div>
<div class="line number8 index7 alt1" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
8</div>
<div class="line number9 index8 alt2" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
9</div>
<div class="line number10 index9 alt1" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
10</div>
<div class="line number11 index10 alt2" style="background: none white !important; border-bottom-color: initial !important; border-bottom-style: initial !important; border-image: initial !important; border-left-color: initial !important; border-left-style: initial !important; border-radius: 0px !important; border-right-color: rgb(108, 226, 108) !important; border-right-style: solid !important; border-top-color: initial !important; border-top-style: initial !important; border-width: 0px 3px 0px 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
11</div>
</td><td class="code" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-bottom: 0px !important; border-image: initial !important; border-left: 0px !important; border-radius: 0px !important; border-right: 0px !important; border-top: 1px solid rgb(231, 231, 231); bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 6px 24px; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: 595.2px;"><div class="container" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: relative !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">
<div class="line number1 index0 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">login: shellUsr</code></div>
<div class="line number2 index1 alt1" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">Password: wy3oo&w4 (não mostra enquanto digita)</code></div>
<div class="line number3 index2 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
</div>
<div class="line number4 index3 alt1" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">-> loadDebug</code></div>
<div class="line number5 index4 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">value = 1 = 0x1</code></div>
<div class="line number5 index4 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;"><br /></code></div>
<div class="line number6 index5 alt1" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">-> setSAPassword_MT ""</code></div>
<div class="line number7 index6 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">ReturnCode = 0x1</code></div>
<div class="line number8 index7 alt1" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">value = 1 = 0x1</code></div>
<div class="line number8 index7 alt1" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;"><br /></code></div>
<div class="line number9 index8 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">-> unld "Debug"</code></div>
<div class="line number10 index9 alt1" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">value = 0 = 0x0</code></div>
<div class="line number11 index10 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="plain plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; text-size-adjust: 160%; top: auto !important; vertical-align: baseline !important; width: auto !important;">-> exit</code></div>
</div>
</td></tr>
</tbody></table>
<div>
Com isso basta acessar através do DS Storage Manager, sem informar a senha.</div>
<div>
<br /></div>
<div>
Não precisa reiniciar.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Fonte: <span style="color: #444444; font-family: Roboto, Helvetica, Arial, sans-serif; font-size: 13px;">https://goo.gl/xcTjUn</span></div>
Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-4005398941491664772018-02-27T21:23:00.002-03:002018-02-27T21:23:42.045-03:00Fonte personalizada no site @font-faceĈ¿<br />
<br />
Trabalho normalmente com CMS, e recebemos muitos layout enviados por nossos clientes. Estes com frequência de fontes que normalmente não se encontram na web.<br />
<br />
Para solucionar o problema utilizo o @font-face, onde você deve subir sua fonte através do FTP e criar uma referencia com o caminho.<br />
<br />
Exemplo<br />
<br />
Dentro do meu arquivo <b>template.css</b>, declaro uma nova fonte <b>Newjune</b>, vinculo o caminho com <span style="background-color: #fafafa; color: #222222;"><b>src: url; e</b></span><span style="background-color: #fafafa; color: #222222;"> por ultimo no </span><span style="background-color: #fafafa; color: #222222;"><b>body</b> utilizo a mesma.</span><br />
<br />
<pre class="prettyprint lang-auto linenums:0 prettyprinted" style="background-color: rgb(250, 250, 250) !important; border-radius: 4px; border: 1px solid rgb(201, 201, 201); line-height: 18.2px; margin: 1em auto; overflow: auto; padding: 1em; width: 635.547px;"><span style="color: #222222;">@font-face {
font-family: NewJune;
src: url('font/NewJuneBook.ttf');
}
body {
font-family: NewJune !important;
}</span></pre>
Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-7764644602665193592017-07-10T11:00:00.000-03:002017-07-10T11:00:27.141-03:00Listar diretórios e tratar caracteres especiaisĈ¿<br />
<br />
dir/a g:\E /s /b > g:\lista.txt<br />
<br />
Depois que realizar o comando para gerar os arquivos.<br />
<br />
Abra o excel, Dados Importar e selecionar ORIGEM DO ARQUIVO MS-DOS (PC-8)Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-10183478340020507672017-05-16T11:50:00.000-03:002017-05-16T11:50:59.642-03:00Acumular valores tabela dinâmica Qlikview Ĉ¿<br />
<br />
Eae já procuraram bastante também ? rsrs<br />
<br />
Com tabela simples funciona assim:<br />
<br />
<span style="background-color: white; font-family: "Droid Sans", "Trebuchet MS", Verdana, sans-serif; font-size: 14px;"><span style="color: #333333;">RangeSum(Above(SUM(</span><b><span style="color: blue;">MEUCAMPO</span></b><span style="color: #333333;">), 0, RowNo()))</span></span><br />
<span style="background-color: white; color: #333333; font-family: "Droid Sans", "Trebuchet MS", Verdana, sans-serif; font-size: 14px;"><br /></span>
<span style="background-color: white;"><span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;">Mas com tabela dinâmica, pensa o que pesquisei e fiz testes.</span></span></span><br />
<span style="background-color: white;"><span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><br /></span></span></span>
<span style="background-color: white;"><span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;">E finalmente cheguei neste cara:</span></span></span><br />
<span style="background-color: white;"><span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><br /></span></span></span>
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;">rangesum(</span></span><br />
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"> Before(</span></span><br />
<span style="font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><span style="color: #333333;"> </span></span></span><span style="color: #333333; font-family: "Droid Sans", "Trebuchet MS", Verdana, sans-serif; font-size: 14px;">SUM(</span><b style="font-family: "Droid Sans", "Trebuchet MS", Verdana, sans-serif; font-size: 14px;"><span style="color: blue;">MEUCAMPO</span></b><span style="color: #333333; font-family: "Droid Sans", "Trebuchet MS", Verdana, sans-serif; font-size: 14px;">)</span><br />
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"> ,0, NoOfColumns(TOTAL)</span></span><br />
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="background-color: white; font-size: 14px;"></span></span><br />
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"> ))</span></span><br />
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><br /></span></span>
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><br /></span></span>
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><br /></span></span>
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;"><br /></span></span>
<br />
<br />
<span style="color: #333333; font-family: Droid Sans, Trebuchet MS, Verdana, sans-serif;"><span style="font-size: 14px;">Base: https://community.qlik.com/thread/201125</span></span>Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-12286877803633936162017-01-31T16:59:00.003-02:002017-01-31T16:59:28.817-02:00Automatizar BKP MS SQL ExpressĈ¿<br />
<br />
Precisei automatizar minhas rotinas de backup de uma instancia do SQL SERVER Express, para foi necessário gerar um script de SQL e outro BAT para agendar execução do windows.<br />
<br />
Isso porque o Express (não possui) o SQL Server Agent, existe algumas alternativas conforme estes links (<a href="https://www.mssqltips.com/sqlservertip/1083/free-job-scheduling-tool-for-sql-server-express-and-msde/" target="_blank">link1</a>, <a href="https://weblogs.asp.net/alex_papadimoulis/Express-Agent-for-SQL-Server-Express_3A00_-Jobs_2C00_-Jobs_2C00_-Jobs_2C00_-and-Mail">link2</a>), mas preferi utilizar o agendamento do windows.<br />
<br />
Primeiro deve ser criar o arquivo .sql<br />
<br />
<div style="background-color: white; line-height: 18.48px;">
<div class="line number1 index0 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: #333333; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-size: 16px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<br /></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">-- Variáveis utilizadas para gerar backup.</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">DECLARE @destino VARCHAR(50), @banco VARCHAR(50)</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">-- O select abaixo pega qual banco iremos realizar o backup,</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">--caso exista mais de um em nossa instância.</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">SELECT @banco = NAME FROM SYS.DATABASES WHERE NAME = 'nome_banco';</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">-- Informamos o destino onde será salvo nosso backup e qual nome o mesmo será salvo.</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">SET @destino = 'G:\Google Drive\BKP_BANCO\' + @banco + REPLACE(CONVERT(VARCHAR(10), GETDATE(), 3), '/', '') + REPLACE(CONVERT(VARCHAR(8), GETDATE(), 108), ':','') + '.BAK';</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">-- Comando para realizar o backup.</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">BACKUP DATABASE @banco</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">-- Salvar no disco.</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<span style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif;"><span style="font-size: 13.2px;">TO DISK = @destino</span></span></div>
<div class="separator" style="background-color: #f7f7f7; clear: both; color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium; line-height: normal;">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;">Não esqueça de alterar as aspas simples</span><br />
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;"><br /></span>
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;">No meu caso mando gerar dentro do diretório do google drive.</span><br />
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;"><br /></span>
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;">Salve este arquivo .sql, sugestão nomebanco.sql, lembrando que este script é para um banco dados repita o sql trocando o nome do banco ou crie outro script para mais banco</span><br />
<div style="font-family: "Times New Roman"; line-height: 18.48px;">
<div class="line number1 index0 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: #333333; direction: ltr !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; font-size: 16px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<br /></div>
<div class="separator" style="background-color: #f7f7f7; clear: both;">
<code class="sql plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 16px; font-stretch: normal; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre-wrap; width: auto !important;">sqlcmd -S SERVIDOR\INSTANCIA -U sa -P senha.12345 -i </code><code class="sql string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 16px; font-stretch: normal; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre-wrap; width: auto !important;">"D:nomebanco.sql"</code></div>
</div>
<br /></div>
<div style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
Agora salve este arquivo .bat e agenda nas tarefas do windows. (Fica dentro de ferramentas administrativas)</div>
<div style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #222222; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 13.2px;">
Fonte: http://t-sql.com.br/backup-sql-server-express/</div>
</div>
Cláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.comtag:blogger.com,1999:blog-6343166358489493085.post-88344933829788664282017-01-16T11:16:00.000-02:002017-01-16T11:16:27.318-02:00Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation.Ĉ¿<br />
<br />
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation.<br />
<br />
<br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;" />
<div style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px; line-height: 18.48px;">
<div class="separator" style="background-color: #f7f7f7; clear: both;">
</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
SELECT </div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>*</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
FROM </div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>A</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
JOIN</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>N ON A.CAMPO_VARCHAR = B.CAMPO_VARCHAR</div>
</div>
<br />
<br />
<br />
Apareceu está mensagem ao realizar um relacionamento com campos VARCHAR ?, simples basta acrescentar o COLLATE conforme exemplo abaixo<br />
<br />
<br />
<div style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px; line-height: 18.48px;">
<div class="separator" style="background-color: #f7f7f7; clear: both;">
</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
SELECT </div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>*</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
FROM </div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>A</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
JOIN</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>N ON A.CAMPO_VARCHAR <b>COLLATE Latin1_General_CI_AS</b> = B.CAMPO_VARCHAR <b>COLLATE Latin1_General_CI_AS </b></div>
</div>
<br />
AttCláudio Generosohttp://www.blogger.com/profile/04002827470733521160noreply@blogger.com