tag:blogger.com,1999:blog-87080569924122543432024-02-18T22:15:45.877-08:00StackAllocСиськи, письки, SharePoint!Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.comBlogger283125tag:blogger.com,1999:blog-8708056992412254343.post-45232850424124462302017-02-15T13:22:00.001-08:002017-02-15T13:24:16.481-08:00Вывести все БД и их размер в SQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">/*</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">database_id name state_desc recovery_model_desc total_size data_size data_used_size log_size log_used_size full_last_date full_size log_last_date log_size</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">8 Tfs_CRMMOSS ONLINE FULL 9071.50 2110.31 1410.13 6961.19 15.72 2016-12-16
21:59:26.000 1388.53 NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">7 Tfs_Configuration ONLINE FULL 1360.00 584.00 516.25 776.00 428.83 NULL NULL NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">10 Tfs_TestCollection ONLINE FULL 656.00 136.00 128.50 520.00 378.02 NULL NULL NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">9 Tfs_SharePointCollection ONLINE FULL 358.31 194.63 188.75 163.69 150.85 2016-12-16
22:32:36.000 173.15 NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">5 ReportServer ONLINE FULL 80.00 8.00 6.69 72.00 14.59 NULL NULL NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">4 msdb ONLINE SIMPLE 46.75 17.94 16.88 28.81 2.25 NULL NULL NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">2 tempdb ONLINE SIMPLE 24.00 16.00 48.13 8.00 4.49 NULL NULL NULL NULL</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">3 model ONLINE FULL 16.00 8.00 2.44 8.00 0.77 NULL NULL NULL NULL</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">6 ReportServerTempDB ONLINE SIMPLE 16.00 8.00 3.75 8.00 2.34 NULL NULL NULL NULL</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">1 master ONLINE SIMPLE 6.00 4.00 3.69 2.00 0.98 NULL NULL NULL NULL</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: green; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">*/</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">IF</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">OBJECT_ID</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'tempdb.dbo.#space'</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">IS</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">NOT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">NULL</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DROP</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TABLE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> #space<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CREATE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TABLE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> #space</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
database_id </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">INT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">PRIMARY</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">KEY</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> data_used_size </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECIMAL</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">18</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> log_used_size </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECIMAL</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">18</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECLARE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> @SQL </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">NVARCHAR</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">MAX</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> @SQL </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">STUFF</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">((</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> USE ['</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">+</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">+</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">']</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> INSERT
INTO #space (database_id, data_used_size, log_used_size)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">
DB_ID()</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> ,
SUM(CASE WHEN [type] = 0 THEN space_used END)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> ,
SUM(CASE WHEN [type] = 1 THEN space_used END)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> FROM (</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> SELECT
s.[type], space_used = SUM(FILEPROPERTY(s.name, ''SpaceUsed'') * 8. / 1024)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> FROM
sys.database_files s</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> GROUP
BY s.[type]</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> ) t;'</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">FROM</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">sys</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">databases</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHERE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">[state] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 0<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">FOR</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">XML</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">PATH</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">''</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">),</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TYPE</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">).</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">value</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'.'</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'NVARCHAR(MAX)'</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">),</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">''</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">EXEC</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">sys</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">sp_executesql</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">@SQL<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">database_id<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">state_desc<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">recovery_model_desc<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> t</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">total_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> t</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">data_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">data_used_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> t</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">log_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">log_used_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> bu</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">full_last_date<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> bu</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">full_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> bu</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">log_last_date<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> bu</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">log_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">FROM </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
database_id<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> log_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CAST</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SUM</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> [type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1 </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> size </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">*</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 8. </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">/</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1024 </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">AS</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECIMAL</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">18</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">))</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> data_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CAST</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SUM</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> [type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 0 </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> size </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">*</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 8. </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">/</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1024 </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">AS</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECIMAL</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">18</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">))</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> total_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CAST</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SUM</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">size</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">*</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 8. </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">/</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1024 </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">AS</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECIMAL</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">18</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">))</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">FROM</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">sys</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">master_files</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">GROUP</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">BY</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> database_id<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> t<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">JOIN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">sys</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: lime; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">databases</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ON</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">database_id </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> t</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">database_id<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">LEFT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">JOIN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> #space s </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ON</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">database_id </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">database_id<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">LEFT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">JOIN</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">database_name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> full_last_date </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">MAX</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> [type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'D'</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> backup_finish_date </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> full_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">MAX</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> [type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'D'</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> backup_size </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> log_last_date </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">MAX</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> [type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'L'</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> backup_finish_date </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> log_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">MAX</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> [type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'L'</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> backup_size </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">FROM </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">database_name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">
s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">[type]<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">
s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">backup_finish_date<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">
backup_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CAST</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">CASE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">backup_size </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">compressed_backup_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">THEN</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">backup_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ELSE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">compressed_backup_size<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">END</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">/</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1048576.0 </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">AS</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DECIMAL</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">18</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">2</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">))</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">
RowNum </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: magenta; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ROW_NUMBER</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">()</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">OVER </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">PARTITION</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">BY</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">database_name</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">[type] </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ORDER</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">BY</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">backup_finish_date </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DESC</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">FROM</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> msdb</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">dbo</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">backupset s<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHERE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> s</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">[type] </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">IN</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">(</span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'D'</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">,</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">'L'</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> f<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WHERE</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> f</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;">RowNum </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> 1<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; font-family: Consolas; font-size: 9.5pt;">
</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">GROUP</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">BY</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> f</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">database_name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">)</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> bu </span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ON</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> d</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> </span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">=</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"> bu</span><span style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-family: Consolas; mso-highlight: white;">database_name</span><span style="background: white; font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<span lang="EN-US" style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 107%; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">ORDER</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt; line-height: 107%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 107%; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt; line-height: 107%;"> t</span><span lang="EN-US" style="background: white; color: grey; font-family: Consolas; font-size: 9.5pt; line-height: 107%; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">.</span><span lang="EN-US" style="background: white; font-family: Consolas; font-size: 9.5pt; line-height: 107%;">total_size </span><span lang="EN-US" style="background: white; color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 107%; mso-ansi-language: EN-US; mso-bidi-font-family: Consolas; mso-highlight: white;">DESC</span><span lang="EN-US"><o:p></o:p></span></div>
</div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-64340181271005955162015-10-23T03:55:00.001-07:002015-10-23T03:55:30.826-07:00Отключение дефолтного gateway у VPN в Windows 10<div dir="ltr" style="text-align: left;" trbidi="on">
При создании VPN всегда автоматически ставится галочка "use default gateway on remote network" в подключении, т.е. весь трафик идёт через VPN.<br />
Раньше всё решалось довольно просто:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWJ3PQ8Fj9VAid9vA0UsWVA5r9YythFD4UjUG71GQ68zoEkB_XZKUzbgmy0iDqbDhHGZC0zlyPBkwzAN6LBdOCiyD32ZGi3qKPppMSrYR3QGeyCdEuOU_QicrZsaew8vZPV6iu6NikIEY/s1600/Windows+VPN+Client+Properties+-+Use+or+not+Use+Default+Gateway+on+Remote+Network.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="377" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWJ3PQ8Fj9VAid9vA0UsWVA5r9YythFD4UjUG71GQ68zoEkB_XZKUzbgmy0iDqbDhHGZC0zlyPBkwzAN6LBdOCiyD32ZGi3qKPppMSrYR3QGeyCdEuOU_QicrZsaew8vZPV6iu6NikIEY/s640/Windows+VPN+Client+Properties+-+Use+or+not+Use+Default+Gateway+on+Remote+Network.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Но в Windows 10 кнопочка "properties" нихера не работает (баг или фича?). Нашёл вариант как галочку снять через powershell:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both;">
Set-VpnConnection -Name "VPN Name" -SplitTunneling $True</div>
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-51382349470526273002014-06-30T08:25:00.002-07:002014-06-30T08:25:55.161-07:00Автоматическое добавление * (asterisk) в поле поиска в Dynamics CRM 2013<div dir="ltr" style="text-align: left;" trbidi="on">
Зайдите на сервере в папку<br />
C:\Program Files\Microsoft Dynamics CRM\CRMWeb\_static\_common\scripts\<br />
<br />
Откройте файл "stage.js" и измените строку:<br />
sFindCriteria=Trim(findCriteria.value.replace(/[\*]+/,"*"));findCriteria.value=sFindCriteria;<br />
и замените на:<br />
sFindCriteria=Trim(findCriteria.value.replace(/[\*]+/,"*"));if (sFindCriteria != "" && sFindCriteria.substr(0, 1) != "*") sFindCriteria = "*" + sFindCriteria;findCriteria.value=sFindCriteria;<br />
<br />
Сбросьте кеш в браузере. Теперь, при вводе в поле поиска значения автоматически будет добавляться в начале знак *, если его там нет.<br />
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-52407535753280603822014-04-25T00:10:00.000-07:002014-04-25T00:10:02.966-07:00100% CPU после установки Workflow Manager 1.0<div dir="ltr" style="text-align: left;" trbidi="on">
Столкнулся с такой проблемой: после установки апдейтов на Workflow Manager 1.0 ушёл в 100% процессор и логи заспамили ошибками типа:<br />
<br />
<i><span style="font-size: x-small;">Failed SQL command after 1 tries with error '229'. Exception: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'InsertTrackingAndStatus', database 'WFInstanceManagementDB', schema 'dbo'.</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)</span></i><br />
<i><span style="font-size: x-small;"> at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)</span></i><br />
<i><span style="font-size: x-small;"> at Microsoft.Workflow.Management.ExecuteNonQueryAsyncResult.OnEndExecuteSql(IAsyncResult result)</span></i><br />
<i><span style="font-size: x-small;"> at Microsoft.Workflow.Management.ExecuteSqlAsyncResult.EndAsyncResult(IAsyncResult result)</span></i><br />
<i><span style="font-size: x-small;"> at Microsoft.Workflow.Common.BackoffRetryAsyncResult.IsolateWithRetry(IAsyncResult result)</span></i><br />
<i><span style="font-size: x-small;"> at Microsoft.Workflow.Common.AsyncResult.AsyncCompletionWrapperCallback(IAsyncResult result)</span></i><br />
<i><span style="font-size: x-small;">ClientConnectionId:03eb9da5-56d7-4023-8802-d7844811bac2 Command Details: SQL Text : InsertTrackingAndStatus</span></i><br />
<i><span style="font-size: x-small;"> SQL Parameters : </span></i><br />
<i><span style="font-size: x-small;"> > @StatusRecords = Microsoft.Workflow.Management.SqlDataAccessProvider+InstanceStatusValuesCollection</span></i><br />
<i><span style="font-size: x-small;"> > @MetadataWithInstanceId = Microsoft.Workflow.Management.SqlDataAccessProvider+MetadataValuesWithInstanceIdCollection</span></i><br />
<i><span style="font-size: x-small;"> > @Variables = Microsoft.Workflow.Management.SqlDataAccessProvider+VariablesCollection</span></i><br />
<i><span style="font-size: x-small;"> > @TrackingRecords = </span></i><br />
<i><span style="font-size: x-small;"> > @StatusHistoryRecords = </span></i><br />
<i><span style="font-size: x-small;"> > @DebugTraceRecords = Microsoft.Workflow.Management.SqlDataAccessProvider+DebugTraceRecordValuesCollection</span></i><br />
<i><span style="font-size: x-small;"> > @RollingStatusHistoryWindowSize = 1000</span></i><br />
<i><span style="font-size: x-small;"> > @RollingDebugTraceWindowSize = 5000</span></i><br />
<div>
<br /></div>
<div>
Чинится просто, нужно выполнить скрипт на БД WFInstanceManagementDB и WFResourceManagementDB, этим мы дадим необходимые права для роли, под которой действует учётка Workflow Manager 1.0:</div>
<div>
<br /></div>
<div>
<div>
<i>IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'WFServiceOperators' AND type = 'R')</i></div>
<div>
<i> BEGIN</i></div>
<div>
<i> -- Grant all permissions of stored procedures and tables</i></div>
<div>
<i> DECLARE @ObjectName sysname, @ObjectType char(20), @Cmd varchar(300)</i></div>
<div>
<i> DECLARE ObjectCursor CURSOR LOCAL FAST_FORWARD</i></div>
<div>
<i> FOR SELECT name, type FROM sys.objects UNION SELECT name, 'WFUDT' FROM sys.types WHERE is_user_defined = 1</i></div>
<div>
<i><br /></i></div>
<div>
<i> OPEN ObjectCursor</i></div>
<div>
<i> FETCH ObjectCursor INTO @ObjectName, @ObjectType</i></div>
<div>
<i> WHILE (@@fetch_status <> -1)</i></div>
<div>
<i> BEGIN </i></div>
<div>
<i> SET @Cmd =</i></div>
<div>
<i> CASE @ObjectType</i></div>
<div>
<i> WHEN 'P' THEN N'GRANT EXECUTE ON [' + @ObjectName + N'] TO [WFServiceOperators]' </i></div>
<div>
<i> WHEN 'WFUDT' THEN N'GRANT CONTROL, REFERENCES ON TYPE::[' + @ObjectName + N'] TO [WFServiceOperators]' </i></div>
<div>
<i> ELSE ''</i></div>
<div>
<i> END</i></div>
<div>
<i><br /></i></div>
<div>
<i> IF @Cmd <> ''</i></div>
<div>
<i> BEGIN</i></div>
<div>
<i> EXEC(@Cmd)</i></div>
<div>
<i> END</i></div>
<div>
<i> FETCH ObjectCursor INTO @ObjectName, @ObjectType</i></div>
<div>
<i> END</i></div>
<div>
<i> CLOSE ObjectCursor</i></div>
<div>
<i> DEALLOCATE ObjectCursor</i></div>
<div>
<i> END</i></div>
<div>
<i> GO</i></div>
</div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-86835663439860456232014-03-15T11:55:00.000-07:002014-03-15T11:55:21.285-07:00Адовое собрание дразнилок<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
Перебранка</h2>
— пошли!<br />
— куда?<br />
— тащить лошадь из пруда я руками за узду а ты губами за пизду<br />
<br />
сёдня суббота девочкам работа мальчикам лежать сосочку сосать<br />
мальчики встали автоматы взяли девочек убили розы положили<br />
<br />
лысый сходи пописай<br />
лохматый сходи покакай<br />
<a name='more'></a><br />
<br />
кто повторяет тот в понос ныряет<br />
а в поносе красный цвет ты ныряешь а я нет<br />
<br />
(в рифму на "ты")<br />
жопой нюхаешь цветы.<br />
а ромашка не моя жопа нюхает твоя.<br />
а цветы железные для моей жопы не полезные.<br />
<br />
— дай мне!<br />
— у тебя рука в говне!<br />
<br />
— дай денег<br />
— поссы на веник<br />
<br />
— дай!<br />
— дай уехал в китай и сказал "никому не давай"<br />
<br />
— покурить оставишь?<br />
— хуй на лавочку поставишь?<br />
— а поставлю, отсосешь?<br />
— а в бумажку завершёшь?<br />
<br />
— покурим?<br />
— покурим у коня под хуем!<br />
<br />
— иди на хуй!<br />
— кусай за хуй злее будешь пиздеть не будешь будешь пиздеть будешь висеть будешь висеть пиздеть будешь схвачен отхуячен<br />
<br />
— чё?!<br />
— хуй через плечо не горячо если горячо переложи на другое плечо<br />
<br />
(в ответ на "конечно")<br />
конюшня твой дом родной<br />
скотный двор твоя дача<br />
<br />
(на вопрос "можно?")<br />
можно машку за ляжку и козу на возу<br />
(вариант) овцу на плацу<br />
<br />
(на реплику "интересно")<br />
интересно когда в троллейбусе (бане) тесно<br />
<br />
— а?<br />
— хуй на!<br />
— жуй два!<br />
— соси четыре у тебя ебало шире.<br />
— соси миллион будешь чемпион.<br />
— соси два миллиона будешь круче чемпиона.<br />
— соси корзину хватит на всю зиму.<br />
— хуёв тебе сарай сиди перебирай.<br />
<br />
— как дела?<br />
— как легла, так и дала<br />
<br />
— спасибо!<br />
— за спасибо ебут красиво<br />
<br />
(в ответ на любую просьбу)<br />
— а хуй до жопы достает?<br />
(если просящий глубоко задумывается) — ну иди выращивай<br />
(если уверенно отвечает, что достает) —вот и еби сам себя в жопу<br />
<br />
— да?<br />
— манда!<br />
<br />
— да?<br />
— в жопе провода!<br />
<br />
какую жвачку любишь — "Bombibom" или "Love is..."?<br />
Отвечавшему "Bombibom" отвечали "хуй столбом", а "Love is..." "хуй отвис"<br />
<br />
(в рифму на слово "ты")<br />
не тыкай а то проткнёшь<br />
<br />
<h2 style="text-align: left;">
Середина</h2>
<div>
<div>
кто в серединке у того яйца на резинке</div>
<div>
а кто по краям тому денежки в карман</div>
<div>
<br /></div>
<div>
кто посерединке тот женится на динке (димке, свинке) </div>
<div>
кто по краям тому по золотым коням</div>
<div>
<br /></div>
<div>
кто посерединке тот кушает ботинки.</div>
<div>
а кто по краям тот кушает банан</div>
</div>
<div>
<br /></div>
<h2 style="text-align: left;">
Очкарики</h2>
очкарик в жопе шарик<br />
наелся кислоты<br />
его похоронили<br />
зарыли под кусты<br />
<br />
очкарик в жопе шарик<br />
пошёл на футбол<br />
очко ему разбили (или: в очки ему насрали)<br />
сказали это гол<br />
<br />
у кого четыре глаза тот похож на унитаза (водолаза)<br />
<br />
<h2 style="text-align: left;">
Дураки</h2>
<div>
<div>
маша дура хвост надула полетела в облака полюбила дурака а дурак не полюбил взял кувалду и убил</div>
<div>
<br /></div>
<div>
дура хвост надула полетела в жопу ягодка влетела</div>
<div>
<br /></div>
<div>
дурак курит табак спички ворует девчонок целует спит под забором зовут его вором</div>
<div>
<br /></div>
<div>
лена дура в лес подула грибы ела обалдела</div>
</div>
<div>
<br /></div>
<h2 style="text-align: left;">
Причёска</h2>
<div>
<div>
поцелуй меня с разбега я за деревом стою</div>
<div>
<br /></div>
<div>
я у мамы вместо швабры головою пол мету</div>
<div>
<br /></div>
<div>
не бей меня мама сырыми трусами</div>
<div>
<br /></div>
<div>
я упала с самосвала тормозила головой</div>
<div>
<br /></div>
<div>
нас бомбили в сорок первом</div>
</div>
<div>
<br /></div>
<h2 style="text-align: left;">
Прочее</h2>
<div>
<div>
сидит дима на заборе</div>
<div>
мочит яйца в ацетоне</div>
<div>
<br /></div>
<div>
встал в позу получил дозу</div>
<div>
<br /></div>
<div>
парась парась ты жопу красками раскрась</div>
<div>
<br /></div>
<div>
иванов-иванов с утра ходит без трусов</div>
<div>
<br /></div>
<div>
и нескладно и неладно у тебя в трусах прохладно</div>
<div>
<br /></div>
<div>
трусы не жопа жопа не алмаз</div>
<div>
писька не сосиска вот и весь рассказ</div>
<div>
<br /></div>
<div>
эй малой сходи за водой</div>
<div>
<br /></div>
<div>
мама не хотела папа не старался</div>
<div>
<br /></div>
<div>
наши раком не стоят (когда кто—то за чем—то нагибался)</div>
<div>
<br /></div>
<div>
писька-волосиська.</div>
<div>
<br /></div>
<div>
доска два соска </div>
<div>
<br /></div>
<div>
едет поезд пассажирный</div>
<div>
восемнадцатый вагон</div>
<div>
а в вагоне женя жырный</div>
<div>
он обжора-чемпион</div>
<div>
<br /></div>
<div>
макака с красной какой</div>
<div>
<br /></div>
<div>
макака-серапука из зарослей бамбука</div>
<div>
<br /></div>
<div>
и не в склад и не в лад поцелуй корову в зад.</div>
<div>
<br /></div>
<div>
у тебя ножки как столбы после бомбёжки</div>
<div>
<br /></div>
<div>
у тебя ляжки как у горляшки.</div>
<div>
<br /></div>
<div>
чо зыришь в штаны напузыришь</div>
<div>
<br /></div>
<div>
ваня лох объелся блох</div>
<div>
сел на лавочку и сдох</div>
<div>
(или: у собаки между ног)</div>
<div>
<br /></div>
<div>
девочки белочки</div>
<div>
сели на тарелочки</div>
<div>
ножки подняли</div>
<div>
фу навоняли</div>
<div>
<br /></div>
<div>
сидит вася на заборе</div>
<div>
в алюминьевых трусах (штанах)</div>
<div>
и кому какое дело</div>
<div>
что ширинка на болтах</div>
<div>
<br /></div>
<div>
наташа три рубля и наша </div>
<div>
<br /></div>
<div>
модница-сковородница</div>
<div>
<br /></div>
<div>
привет правое яйцо</div>
<div>
привет левое яйцо</div>
<div>
что за палка между нами</div>
<div>
колоти ее ногами</div>
<div>
<br /></div>
<div>
будь другом насри кругом </div>
<div>
<br /></div>
<div>
будь братом насри квадратом</div>
<div>
<br /></div>
<div>
он какой-то не такой </div>
<div>
в попу лазает рукой </div>
<div>
писю трогает губами</div>
<div>
он наверно голубой</div>
<div>
<br /></div>
<div>
ябеда-корябеда турецкий барабан</div>
<div>
кто на нем играет васька-таракан</div>
<div>
<br /></div>
<div>
девчонки-печёнки съели поросёнка</div>
<div>
поросёнок жирный поезд пассажирный</div>
<div>
<br /></div>
<div>
жадина-говядина солёный огурец</div>
<div>
на полу валяется никто его не ест</div>
<div>
<br /></div>
<div>
жиртрест-пром-сосиска</div>
<div>
<br /></div>
<div>
жиртрест мясокомбинат промсосиска автомат</div>
<div>
<br /></div>
<div>
повторюша </div>
<div>
дядя-хрюша</div>
<div>
всю помойку облизал</div>
<div>
а спасибо не сказал </div>
<div>
а в помойке водолаз,</div>
<div>
тебя съел а меня спас</div>
<div>
<br /></div>
<div>
(вариант)</div>
<div>
повторюшка</div>
<div>
дядя хрюшка</div>
<div>
из помойного ведра</div>
<div>
тебя мама целовала</div>
<div>
и сказала: ты свинья</div>
<div>
<br /></div>
<div>
мальчик тунёвый</div>
<div>
жоркий поскрёбыш</div>
<div>
споливенький</div>
<div>
хилый поёбыш.</div>
<div>
к чертям катись</div>
<div>
сёдня и надысь</div>
<div>
<br /></div>
<div>
малыши-карандаши</div>
<div>
взяли палки и пошли</div>
<div>
старшие догнали</div>
<div>
палки отобрали</div>
<div>
малыши заплакали</div>
<div>
и в штаны накакали</div>
<div>
<br /></div>
<div>
шел по крыше воробей нёс баночку соплей кто хоть раз пикнет тот её выпьет</div>
<div>
<br /></div>
<div>
шёл солдат по полю боя нёс двенадцать банок гноя кто слово пикнет тот её и выпьет</div>
<div>
<br /></div>
<div>
раз-два мы не ели</div>
<div>
три-четыре есть хотим</div>
<div>
открывайте шире двери</div>
<div>
а то повара съедим</div>
<div>
поварятами закусим</div>
<div>
а вожатыми запьем</div>
<div>
а дежурных по столовой</div>
<div>
на добавки разнесем</div>
<div>
<br /></div>
<div>
кто носит фирму найки того ебут незнайки</div>
<div>
кто носит фирму адидас тот настоящий пидарас</div>
<div>
<br /></div>
<div>
сопля голландская жопа американская</div>
<div>
<br /></div>
<div>
я на ракете а ты в туалете</div>
<div>
<br /></div>
<div>
петя петя лапоток</div>
<div>
съел у бабушки пирог</div>
<div>
с тараканом дрался</div>
<div>
чуть не обосрался</div>
<div>
<br /></div>
<div>
(про щербатого)</div>
<div>
щербель дай рубель! </div>
<div>
<br /></div>
<div>
(если случайно показала нижнее бельё)</div>
<div>
кто не видел трикотаж детский мир второй этаж</div>
<div>
<br /></div>
<div>
(в ответ на жесты)</div>
<div>
рожки факи и хуи это признаки любви</div>
</div>
<div>
<br /></div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-3037530398108791272014-03-15T11:37:00.000-07:002014-03-15T11:38:45.448-07:00Сравнение систем хранения кода в TFS: TFVC vs Git<div dir="ltr" style="text-align: left;" trbidi="on">
Microsoft TFS 2012 и 2013 стал поддерживать две системы хранения кода.<br />
<b>TFVC </b>- Team Foundation Version Control, стандартная для TFS централизованная система хранения кода. Все изменения фиксируются на сервере, в том числе и branch. Т.е. актуальный код всегда в TFS.<br />
<b>Git </b>- это DVCS (Distributed Version Control System), это означает, что как такового центрального репозитария нет и TFS в данном случае выступает как "один из" репозитариев. Причём репозитарием может быть даже машина разработчика. Следствием этого мы поулчаем самую разрекламирвоанную фишку Git - разработчик может на своей машине делать бесконечное количетство branch, не тревожа TFS.<br />
<br />
Побробнее свои изыскания изобразил на mind map, но у меня абсолютный перекос на TFVC, так что не судите строго. Ещё дублируютя доводы: если есть недостатки в одной системе, это значит, что есть такие же преимущества в другой.<br />
<br />
<a href="http://www.mindmeister.com/389407396/tfvc-vs-git">http://www.mindmeister.com/389407396/tfvc-vs-git</a><br />
<br />
<br />
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-31062659196439777252013-11-06T09:30:00.001-08:002013-11-06T09:30:19.281-08:00Код на World Of Tanks<div dir="ltr" style="text-align: left;" trbidi="on">
3 дня премиума, 500 золота, какой-то танк T2LT.<br />
Действителен до 01.03.2014, активируется один раз.<br />
<br />
BNT8Z-298U6-SF6V3-38MKK</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-64920691923914750782013-10-11T03:44:00.000-07:002013-10-11T03:44:09.394-07:00Старинные русские ругательства<div dir="ltr" style="text-align: left;" trbidi="on">
Ащеул — пересмешник, зубоскал.<br />
Баба ветрогонка — вздорная (нар.)<br />
Баляба — рохля, разиня (арх.)<br />
Баламошка — дурачекъ, полоумный зряшный<br />
Балахвостъ — волокита (о мужчине) (диал.)<br />
Басалай — грубиянъ (отъ «баса» и «лай» — «красиво лаяться») (волог.)<br />
Безпелюха — неряха, рохля, разиня (ур.)<br />
Безсоромна баба — бесстыжая (нар.)<br />
Белебеня — пустоплетъ (кур.)<br />
Бзыря — бешеный повеса, шатунъ (нар.)<br />
Бобыня — надутый, чванливый (тул., влад.)<br />
Божевольный — худоумный, дурной (стар.)<br />
Божедурье — природный дуракъ (стар.)<br />
Болдырь — пузырь, надутый (нар.)<br />
Блудоумъ — волокита, несмыселъ (нар.)<br />
Блудяшка — гуляка (диал.)<br />
Бредкий — говорливый, болтливый (отъ «бредъ»)<br />
Брыдлый — гадкий, вонючий (стар.)<br />
Буня — спесивый, чванливый (ряз., тамб.)<br />
Буслай — мот, гуляка (др. рус.)<br />
Валандай — бездельник, лодырь (север.)<br />
Вертопрахъ — продувной ветрогонъ, гуляка (стар.)<br />
Визгопряха — непоседливая девка (нар.)<br />
Волочайка — распутная жена (олон.)<br />
Вымесокъ — выродок (стар.)<br />
Выпоротокъ — недоносокъ (олон.)<br />
Вяжихвостка — сплетница (орл.)<br />
Глазопялка — любопытный (-ая) (моск., яросл.)<br />
Глуподырый (глупендяй, глупеня) — глупый (нар.)<br />
Грабастикъ — воръ, грабитель (диал.)<br />
Гузыня — плакса, рёва («разгузыниться» — расплакаться)<br />
Гульня — непотребная, гулящая баба<br />
Дитка — некошный, нечистый (кур.)<br />
Дуботолкъ (Дроволомъ) — дуракъ (нар.)<br />
Дурка — сумасшедшая, дура (укр.)<br />
Елдыга — бранчливый (нар.)<br />
Еропка — надутый, чванливый (тул.)<br />
Ерохвостъ — задира, спорщик (нар.)<br />
Ерпыль — малорослый, торопыга (пенз.)<br />
Ёнда (Шлёнда) — непотребная баба (арх.)<br />
Ёра — озорная, бойкая на языкъ (пенз., твер.)<br />
Жиздоръ — задира (раз.)<br />
Загузастка — круглая, толстая девка или баба (нар.)<br />
Задоръ-баба — бранчливая, бойкая (нар.)<br />
Заовинникъ — деревенский волокита (нар.)<br />
Затетёха — дородная бабища (нар.)<br />
Захухря — нечёса, неряха, растрепа (кал., ряз.)<br />
Кащей — жадный (стар.)<br />
Киселяй — вялый (пск., твер.)<br />
Колобродъ — шатунъ, бездельникъ (нар.)<br />
Коломесъ — вздор говорящий (нар.)<br />
Колотовка — драчливая и сварливая баба (орл.)<br />
Колупай — мешковатый, медлительный (нар.)<br />
Королобый — крепкоголовый, тупой, глупый (нар.)<br />
Костеря — брюзга, ворчунъ (нар.)<br />
Кропотъ — ворчунъ (стар.)<br />
Куёлда — сварливый (-ая), вздорный (-ая) (диал.)<br />
Курощупъ — бабникъ, волокита (нар.)<br />
Ледаша детина — негодный, плохой (нар.)<br />
Лежака — лентяйка (ворон.)<br />
Лободырный — недоумокъ (нар.)<br />
Лоха — дура (пск., твер.)<br />
Лоший — дурной, плохой (костр.)<br />
Лудъ — дуракъ (отъ «лудить» — вводить в заблуждение, обманывать) (др.слав.)<br />
Любомудръ — любящий мудрствовать, затейный (др.рус.)<br />
Лябзя (лябза) — болтунъ, пустомеля (олон.)<br />
Мамошка — публичная женщина (диал.)<br />
Маракуша — противный человекъ (кандалакш.)<br />
Межеумокъ — человекъ гораздо средний (стар.)<br />
Михрютка — неуклюжий, неловкий (диал.)<br />
Младоуменъ суще — глуп смолоду (др.рус.)<br />
Мордофиля — чванливый дуракъ (стар.)<br />
Моркотникъ — человек безъ понятия (лешукон.)<br />
Москолудъ — шутникъ, проказникъ, дурачекъ (от «маска лудъ») (др.рус.)<br />
Мухоблудъ — лентяй, лежебока (стар.)<br />
Насупа — угрюмый, хмурый (диал.)<br />
Насупоня — надутый, сердитый (нар.)<br />
Невегласъ — темный, невежа (др.рус.)<br />
Негораздокъ — недалекий (пск.)<br />
Неповоротень — неуклюжий (стар.)<br />
Несмыселъ — глупецъ (стар.)<br />
Нефырь — неугодный, непотребный (волог.)<br />
Обдувало — обманщикъ, плутъ (стар.)<br />
Обломъ — грубый, невежа (стар.)<br />
Облудъ — обманщикъ (др.рус.)<br />
Огуряла — безобразникъ («огурство чинить всякое» — безобразничать) (др.рус.)<br />
Окаёмъ — отморозок (стар.)<br />
Околотень — неслухъ, дурень (др.рус.)<br />
Остолбень — дуракъ (стар.)<br />
Охальникъ — безобразникъ (нар.)<br />
Пеньтюхъ — пузатый, жопистый (твер.раз.)<br />
Пехтюкъ — неповоротливый, обжора (пск., твер.)<br />
Печегнётъ — лентяй (нар.)<br />
Печная ездова — лентяйка (нар.)<br />
Плеха — женщина легкого поведения (стар.)<br />
Попрешница — спорщица (моск.)<br />
Потатуй — потаковщикъ, потатчикъ, подхалимъ (др.рус.)<br />
Похабникъ — ругатель, сквернословъ (стар.)<br />
Пресноплюй — пустобай, болтунъ (нар.)<br />
Псоватый — на пса похожий (нар.)<br />
Пустобрёхъ — болтунъ (нар.)<br />
Пустошный — пустой, глупый, зряшный (диал.)<br />
Пыня — гордая, надутая, недоступная (как правило о женщине) (кал.)<br />
Пятигузъ — ненадежный, попятный (нар.)<br />
Развисляй — неряха, рохля, разиня (моск.)<br />
Разлямзя — неповоротливый, вялый (пск.)<br />
Разноголовый — неразумный, недогадливый (помор.)<br />
Разтетёха — плотная, жирная девка, баба (нар.)<br />
Растопча — разиня, олухъ (тамб.)<br />
Расщеколда — болтливая баба (нар.)<br />
Рахубникъ — безобразникъ (рахубничать — безобразничать) (сев.)<br />
Рюма — плакса (отъ «рюмить» — плакать)<br />
Свербигузка — девка непоседа (нар.)<br />
Сдёргоумка — полудурокъ (нар.)<br />
Сиволапъ — неуклюжий, грубый мужикъ (нар.)<br />
Скапыжный — сварливый, вздорный (тарусск.)<br />
Скоблёное рыло — со сбритой бородой (стар.)<br />
Скаредъ — скупой, жадный (др.рус.)<br />
Сквернавецъ (Сквернодей)- нехорошо, скверно поступающий (стар.)<br />
Сняголовь (Сняголовый) — головорезъ, сорвиголова, лихъ человекъ (Сняголовить — безобразничать, хулиганить) (вят., перм.)<br />
Стерва — падаль, стервятина (др.рус.)<br />
Страмецъ — срамецъ, безстыдникъ (стар., ур.)<br />
Страхолюдъ — урод (нар.)<br />
Суемудръ — ложно премудрый (др.рус.)<br />
Тартыга — пьяница, буянъ («тартыжничать — безобразить) (влад.)<br />
Телеухъ — олухъ, глупый (перм.)<br />
Тетёшка — гулящая баба (нар.)<br />
Титёшница — баба с большими титьками (моск.)<br />
Толоконный лобъ — дуракъ (отъ «толокно»)<br />
Трупёрда — неповоротливая баба (диал.)<br />
Трясся — сварливая, вздорная баба (нар.)<br />
Туесъ — бестолочь (иносказ.)<br />
Тьмонеистовый — невежа (стар.)<br />
Тюрюхайло — неряха (кур.)<br />
Угланъ — повеса (вят., перм., каз.)<br />
Урюпа — плакса, замарашка, неряха (нар.)<br />
Фетюкъ — оскорбление в адрес мужчины<br />
Фофанъ — простофиля, дуракъ (орл.)<br />
Фуфлыга — прыщь, дутикъ, невзрачный маленький мужичекъ («фуфлыжничать» — шататься, жить за чужой счетъ) (нар.)<br />
Хабалъ — нахалъ, смутьянъ, грубиянъ (олон.)<br />
Хандрыга (ханыга) — праздный шатунъ (диал.)<br />
Хмыстень — вор (моск.)<br />
Хохрикъ — горбатый (нар.)<br />
Хобяка — неуклюжий неловкий (тул.)<br />
Чёртъ верёвочный — сумасбродъ (стар.)<br />
Чужеядъ — паразит, нахлебник (др.рус.)<br />
Шаврикъ — кусокъ дерьма (моск.)<br />
Шалава — дуракъ, глупый (перм.)<br />
Шалопутъ — беспутный, ветрогонъ (стар.)<br />
Шинора — проныра (кольск.)<br />
Шлында — бродяга, тунеядец (смол.)<br />
Шпынь голова — нечёсаный (нар.)<br />
Щаулъ — зубоскалъ (др.рус.)<br />
<div>
<br /></div>
<div>
Источник: <a href="http://sputnikipogrom.com/">http://sputnikipogrom.com/</a></div>
<div>
<br /></div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-19895885410394100902013-09-26T06:45:00.002-07:002013-09-26T06:45:18.902-07:00Вывести все таблицы и количество строк в них в SQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span class="coMULTI" style="border: 0px; color: #406040; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">/*</span><span class="coMULTI" style="border: 0px; color: #406040; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><br style="line-height: 1em;" />SchemeName TableName RowsInTable ReservedSpace DataSpace IndexSpace <br style="line-height: 1em;" />Sales SalesDet 121317 15752 KB 9880 KB 5312 KB <br style="line-height: 1em;" />Prod TransHist 113443 9920 KB 6304 KB 3192 KB <br style="line-height: 1em;" />...<br style="line-height: 1em;" />*/</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DECLARE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @cn </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">int</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, @m </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">int</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, @t sysname, @sn </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">varchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">256</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, @fn </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">varchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">256</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DECLARE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @spsUsed </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">TABLE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">s sysname </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">NULL</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DEFAULT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">NULL</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, n </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">nvarchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">128</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, rs </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">char</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">11</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, rsr </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">varchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">18</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, dt </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">varchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">18</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, idx</span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">varchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">18</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, uns </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">varchar</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">18</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DECLARE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @tables </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">TABLE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">n sysname, s </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">int</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, id </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">int</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">IDENTITY</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">NOCOUNT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ON</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">INSERT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">INTO</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @tables </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> name, schema_id </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">FROM</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> sys.</span><span class="me1" style="border: 0px; color: #0080ff; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">objects</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> type </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="st0" style="border: 0px; color: #c03030; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">'U'</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @m</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="kw2" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">@@ROWCOUNT</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @cn </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">1</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WHILE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @cn </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @m </span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BEGIN</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @t </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> n </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">FROM</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @tables </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> id</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">@cn</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @sn </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> SCHEMA_NAME</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> s </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">FROM</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @tables </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> id</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">@cn</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @fn</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">@sn</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">+</span><span class="st0" style="border: 0px; color: #c03030; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">'.'</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">+</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">@t</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">INSERT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">INTO</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @spsUsed </span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">n,rs,rsr,dt,idx,uns</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">EXECUTE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw3" style="border: 0px; color: teal; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sp_spaceused</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @fn</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">UPDATE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @spsUsed </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> s</span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">@sn </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> s </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">IS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">NULL</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @cn </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @cn </span><span class="sy0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">+</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="nu0" style="border: 0px; color: #0080a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">1</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">END</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> s </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> SchemeName, n </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> TableName, rs </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> RowsInTable, rsr </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> ReservedSpace, dt </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> DataSpace, idx </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> IndexSpace, uns </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">AS</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">NotYetUsedSpace </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">FROM</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> @spsUsed</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ORDER</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BY</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">CONVERT</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">int</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;">, rs</span><span class="br0" style="border: 0px; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DESC</span><br style="font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;" /><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SET</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">NOCOUNT</span><span style="background-color: #f9f9f9; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px;"> </span><span class="kw1" style="border: 0px; color: #2060a0; font-family: 'Anonymous Pro', Monaco, monospace; font-size: 15px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">OFF</span></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-52161210798338714832013-08-30T13:51:00.003-07:002013-08-30T13:51:28.444-07:00Давно не было пошлостей<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuFXz0n_GkUF6QFu2uO9_yF6koTgTz4uyjSI3o40lXQWnWkV_2tLTzVzN7e5EdMTuwk1_Xgwer4VSo92rZdpk5YfvPKiqqzWwXCXr-kiCyT_gqf1ciJwWlWWNIVoL10b6qwhE30oxhg9w/s1600/1322501766_1001.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuFXz0n_GkUF6QFu2uO9_yF6koTgTz4uyjSI3o40lXQWnWkV_2tLTzVzN7e5EdMTuwk1_Xgwer4VSo92rZdpk5YfvPKiqqzWwXCXr-kiCyT_gqf1ciJwWlWWNIVoL10b6qwhE30oxhg9w/s1600/1322501766_1001.gif" /></a></div>
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-37987286806529847002013-08-29T10:32:00.002-07:002013-09-26T06:49:37.874-07:00Уличные фразы (пополняется)<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif;"><span style="line-height: 17px;">Рецепт как жениться от бабы в электричке: в школе не подцепила, в инсте не подцепила... всё! Интернет! Интернет!</span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif;"><span style="line-height: 17px;"><br /></span></span></div>
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif;"><span style="line-height: 17px;">Я рассталась со вторым через 10 лет. Жалею иногда, трахал как конь, я еле выползала. Ни до ни после так больше не было</span></span><br />
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif;"><span style="line-height: 17px;"><br /></span><span style="line-height: 17px;">Про отсутствие секса: у Лены комендантский час.</span></span><br />
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif;"><span style="line-height: 17px;"><br /></span></span>
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif;"><span style="line-height: 17px;">Каждый день в KFC на Белорусской: Вам пять <b>крылов</b>, да?</span></span><br />
<br />
<div style="text-align: left;">
<span style="color: #333333; font-family: lucida grande, tahoma, verdana, arial, sans-serif; font-size: x-small;"><span style="line-height: 17px;"><br /></span></span></div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-61954723886068380352013-07-08T09:06:00.002-07:002013-07-08T09:07:21.754-07:00Отдаю ключ на ABBYY Lingvo x5 Английский язык Домашняя версия<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px;"> </span><strong style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px;">LERS-1500-0003-1693-9595-0623</strong><br />
<strong style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px;"><br /></strong>
<br />
<div style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px;">
Ссылка на полный дистрибутив для ПК в одном файле (1,71 ГБ):<br />
<a href="http://abbyy.us5.list-manage1.com/track/click?u=9cb66c72c2b4a6a903ab272b6&id=72cba23484&e=9b920bc681" style="color: #c50b2f; font-family: Verdana;" target="_blank">http://fr7.abbyy.com/LingvoX5/<wbr></wbr>ABBYY_Lingvo_x5_Home_edition_<wbr></wbr>English.exe</a></div>
<div style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px;">
Подробную информацию по активации продукта можно найти по ссылке:<br />
<a href="http://abbyy.us5.list-manage.com/track/click?u=9cb66c72c2b4a6a903ab272b6&id=94ba960173&e=9b920bc681" style="color: #c50b2f; font-family: Verdana;" target="_blank">http://activation.abbyy.ru/<wbr></wbr>default_rus.asp</a><br />
<br />
Нахуя оно мне?!</div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-17604100297163667902013-07-08T08:30:00.000-07:002013-07-08T08:30:01.590-07:00Распитие и продажа спиртных напитков<div dir="ltr" style="text-align: left;" trbidi="on">
Решил, что надо где-то хранить мои обращения, а то постоянно забываю дату написания, чтобы потом потроллить прокуратуру за нерасторомпность госорганов. Я верю, мир можно сделать лучше, нужно всего лишь напрячь жопу.<br />
<br />
<i>Добрый день!</i><br />
<i>Гуляя вечером (после 23:00) по новомытищинскому проспекту, я вижу магазины, торгующие спиртным в ночное время по следующим адресам:</i><br />
<i>- палатка на углу пересечения новомытищинского проспекта и улицы щербакова;</i><br />
<i>- новомытищинский проспект 47А.</i><br />
<i>Это является нарушением федерального закона №171-ФЗ от 22 ноября 1995г. (в редакции закона №218-ФЗ от 18.07.2011г.), не допускающего розничной продажи пива и пивных напитков независимо от процентного содержания этилового спирта в данной продукции на территории Московской области с 21.00 до 11.00 часов.</i><br />
<i>Также в сквере им. Стрекалова (напротив новомытищинский проспект 47А) постоянно вечером распивают водку и прочие крепкие алкогольные напитки, что нарушает статью 20.20 КоАП РФ.</i><br />
<i>Прошу вас:</i><br />
<i>1. Устранить нарушение федерального закона, запретив торговать спиртным в ночное время.</i><br />
<i>2. Провести вечером проверку в сквере им. Стрекалова на предмет нарушения закона о распитии крепких алкогольных напитков в общественных местах.</i></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-32798325532962182262013-07-01T00:48:00.003-07:002013-07-01T00:48:57.262-07:00Очистить все события в журналах (EventLogs)<div dir="ltr" style="text-align: left;" trbidi="on">
Делаем файл "ClearAllEvents.ps1":<br />
<br />
<i>Param(</i><br />
<i><span class="Apple-tab-span" style="white-space: pre;"> </span>[string]<span class="Apple-tab-span" style="white-space: pre;"> </span>$computerName = "localhost"</i><br />
<i>)</i><br />
<i><br /></i>
<i>$logs = get-eventlog -computername $computername -list | foreach {$_.Log} | foreach {clear-eventlog -comp $computername -log $_ }</i><br />
<i>get-eventlog -computername $computername -list</i></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-31008929711776712622013-07-01T00:29:00.000-07:002013-07-01T00:29:07.622-07:00Как сменить контроллёр домена (удалив старый)<div dir="ltr" style="text-align: left;" trbidi="on">
Натрахался изрядно, пока не нашёл нормальную статью как и что делать. Статья старая, но разницы никакой.<br />
<br />
<a href="http://support.microsoft.com/kb/555846">http://support.microsoft.com/kb/555846</a><br />
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-45716760351039967572013-06-20T03:07:00.000-07:002013-06-20T03:07:32.381-07:00Как найти/выделить все картинки в Word<div dir="ltr" style="text-align: left;" trbidi="on">
В поиске вводим "^g" - найдёт все картинки.<br />
Чтобы применить к ним стиль, нужно запустить поиск и замену, в поле поиска ввести "^g", а в замене указать какой стиль к ним применить, например, рамочку.</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-33149180567086147802013-06-17T02:26:00.002-07:002013-06-17T02:26:50.176-07:00Подсчитать количество пользователей в Active Directory<div dir="ltr" style="text-align: left;" trbidi="on">
(get-aduser -filter *|where{$_.enabled}).count</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-81826958631726189032013-06-10T03:11:00.001-07:002013-06-10T03:11:23.263-07:004 лекции по технологиям виртуализации Microsoft<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<b>День 1. Виртуализация серверов: Технологии и лицензирование<u></u><u></u></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Докладчики: Вероника Ленькова, Николай Иванов (Microsoft)</div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Видеозапись (250 МБ) и презентация на SkyDrive: <a href="http://sdrv.ms/149YNFk" style="color: #1155cc;" target="_blank">http://sdrv.ms/149YNFk</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<img border="0" class="" height="268" src="https://mail.google.com/mail/u/0/?ui=2&ik=48ff52a3a3&view=att&th=13f2ceae7d102189&attid=0.1&disp=emb&zw&atsh=1" width="511" /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<b>День 2. Проект по виртуализации инфраструктуры: мастер-класс<u></u><u></u></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Докладчики: Илья Задворошный, Андрей Выставкин (Microsoft)</div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Видеозапись (246 МБ) и презентация на SkyDrive: <a href="http://sdrv.ms/149YNFk" style="color: #1155cc;" target="_blank">http://sdrv.ms/149YNFk</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<img border="0" class="" height="277" src="https://mail.google.com/mail/u/0/?ui=2&ik=48ff52a3a3&view=att&th=13f2ceae7d102189&attid=0.2&disp=emb&zw&atsh=1" width="443" /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<b>День 3. Виртуализация рабочих мест: Технологии и лицензирование<u></u><u></u></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Докладчики: Вероника Ленькова, Николай Иванов, Илья Задворошный (Microsoft)</div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Видеозапись (208 МБ) и презентация на SkyDrive: <a href="http://sdrv.ms/149YNFk" style="color: #1155cc;" target="_blank">http://sdrv.ms/149YNFk</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<img border="0" class="" height="248" src="https://mail.google.com/mail/u/0/?ui=2&ik=48ff52a3a3&view=att&th=13f2ceae7d102189&attid=0.3&disp=emb&zw&atsh=1" width="516" /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<b>День 4. Мониторинг, управление и защита рабочих станций в корпоративной среде с помощью продуктов System Center 2012 SP1<u></u><u></u></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Докладчики: Андрей Выставкин, Максим Синельников, Георгий Гаджиев, Андрей Борзенко (Microsoft)</div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
Видеозапись (315 МБ) и презентация на SkyDrive: <a href="http://sdrv.ms/149YNFk" style="color: #1155cc;" target="_blank">http://sdrv.ms/149YNFk</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">
<img border="0" class="" height="247" src="https://mail.google.com/mail/u/0/?ui=2&ik=48ff52a3a3&view=att&th=13f2ceae7d102189&attid=0.4&disp=emb&zw&atsh=1" width="443" /></div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-7983138167159817312013-05-25T14:56:00.001-07:002013-05-25T14:56:42.833-07:00Выполнение PowerShell в коде программы .Net<div dir="ltr" style="text-align: left;" trbidi="on">
Так как powershell и .Net очень близки, то помимо стандартного варианта "вызвать исполняемый файл powershell из кода и передать ему команды", есть и более красивый/умный вариант - через объектную модель PowerShell.<br />
<br />
За работу с PowerShell отвечает сборка "System.Management.Automation.dll". Она ставится вместе с SDK или же через NuGet:<br />
<i><b>Install-Package System.Management.Automation</b></i><br />
<br />
После этого пишем простенький метод:<br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<style type="text/css">
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: Consolas, "Courier New", Courier, Monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #a31515; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
</style>
<br />
<div class="csharpcode">
<pre class="alt"><span class="lnum"> 1: </span><span class="kwrd">using</span> System.Management.Automation.Runspaces;</pre>
<pre><span class="lnum"> 2: </span><span class="kwrd">using</span> System.Text;</pre>
<pre class="alt"><span class="lnum"> 3: </span> </pre>
<pre><span class="lnum"> 4: </span><span class="kwrd">namespace</span> PowerShell</pre>
<pre class="alt"><span class="lnum"> 5: </span>{</pre>
<pre><span class="lnum"> 6: </span> <span class="kwrd">public</span> <span class="kwrd">class</span> PowerShellInterpreter</pre>
<pre class="alt"><span class="lnum"> 7: </span> {</pre>
<pre><span class="lnum"> 8: </span> <span class="kwrd">public</span> <span class="kwrd">string</span> Execute(<span class="kwrd">string</span> command)</pre>
<pre class="alt"><span class="lnum"> 9: </span> {</pre>
<pre><span class="lnum"> 10: </span> <span class="kwrd">var</span> runspace = RunspaceFactory.CreateRunspace();</pre>
<pre class="alt"><span class="lnum"> 11: </span> <span class="kwrd">var</span> executeResult = <span class="kwrd">new</span> StringBuilder();</pre>
<pre><span class="lnum"> 12: </span> <span class="kwrd">try</span></pre>
<pre class="alt"><span class="lnum"> 13: </span> {</pre>
<pre><span class="lnum"> 14: </span> runspace.Open();</pre>
<pre class="alt"><span class="lnum"> 15: </span> </pre>
<pre><span class="lnum"> 16: </span> <span class="kwrd">var</span> pipeline = runspace.CreatePipeline();</pre>
<pre class="alt"><span class="lnum"> 17: </span> pipeline.Commands.AddScript(command);</pre>
<pre><span class="lnum"> 18: </span> </pre>
<pre class="alt"><span class="lnum"> 19: </span> <span class="kwrd">var</span> result = pipeline.Invoke();</pre>
<pre><span class="lnum"> 20: </span> <span class="kwrd">foreach</span> (<span class="kwrd">var</span> psObject <span class="kwrd">in</span> result)</pre>
<pre class="alt"><span class="lnum"> 21: </span> {</pre>
<pre><span class="lnum"> 22: </span> executeResult.AppendLine(psObject.ToString());</pre>
<pre class="alt"><span class="lnum"> 23: </span> }</pre>
<pre><span class="lnum"> 24: </span> }</pre>
<pre class="alt"><span class="lnum"> 25: </span> <span class="kwrd">finally</span></pre>
<pre><span class="lnum"> 26: </span> {</pre>
<pre class="alt"><span class="lnum"> 27: </span> runspace.Close();</pre>
<pre><span class="lnum"> 28: </span> }</pre>
<pre class="alt"><span class="lnum"> 29: </span> <span class="kwrd">return</span> executeResult.ToString();</pre>
<pre><span class="lnum"> 30: </span> }</pre>
<pre class="alt"><span class="lnum"> 31: </span> }</pre>
<pre><span class="lnum"> 32: </span>}</pre>
</div>
<br />
Сначала мы создаём "Runspace" - это что-то типа инстанса powershell в памяти, который может обрабатывать поступающие команды (pipeline). Запихиваем в pipeline команду и просим её выполнить (Invoke), в результате получаем массив <a href="http://msdn.microsoft.com/en-us/library/system.management.automation.psobject(v=vs.85).aspx">PSObject </a>(базовый объект powershell). Результат выполнения команд в PowerShell может быть многострочным, поэтому именно массив, а не один объект. Далее мы эти объекты объединяем в строку и возвращаем результат.<br />
<br />
Вот такой код можно используем для проверки:<br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<style type="text/css">
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: Consolas, "Courier New", Courier, Monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #a31515; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
</style>
<div class="csharpcode">
<pre class="alt"><span class="lnum"> 1: </span><span class="kwrd">using</span> System;</pre>
<pre><span class="lnum"> 2: </span><span class="kwrd">using</span> Microsoft.VisualStudio.TestTools.UnitTesting;</pre>
<pre class="alt"><span class="lnum"> 3: </span> </pre>
<pre><span class="lnum"> 4: </span><span class="kwrd">namespace</span> PowerShell</pre>
<pre class="alt"><span class="lnum"> 5: </span>{</pre>
<pre><span class="lnum"> 6: </span> [TestClass]</pre>
<pre class="alt"><span class="lnum"> 7: </span> <span class="kwrd">public</span> <span class="kwrd">class</span> PowerShell</pre>
<pre><span class="lnum"> 8: </span> {</pre>
<pre class="alt"><span class="lnum"> 9: </span> [TestMethod]</pre>
<pre><span class="lnum"> 10: </span> <span class="kwrd">public</span> <span class="kwrd">void</span> PowerShellExcuteTest()</pre>
<pre class="alt"><span class="lnum"> 11: </span> {</pre>
<pre><span class="lnum"> 12: </span> <span class="kwrd">var</span> interpreter = <span class="kwrd">new</span> PowerShellInterpreter();</pre>
<pre class="alt"><span class="lnum"> 13: </span> <span class="kwrd">const</span> <span class="kwrd">string</span> command = <span class="str">"$psversiontable.psversion"</span>;</pre>
<pre><span class="lnum"> 14: </span> <span class="kwrd">var</span> result = interpreter.Execute(command);</pre>
<pre class="alt"><span class="lnum"> 15: </span> <span class="kwrd">const</span> <span class="kwrd">string</span> expected = <span class="str">"3.0\r\n"</span>;</pre>
<pre><span class="lnum"> 16: </span> </pre>
<pre class="alt"><span class="lnum"> 17: </span> Assert.AreEqual(expected, result);</pre>
<pre><span class="lnum"> 18: </span> }</pre>
<pre class="alt"><span class="lnum"> 19: </span> }</pre>
<pre><span class="lnum"> 20: </span>}</pre>
</div>
<pre class="csharpcode" style="background-color: white; font-family: Consolas, 'Courier New', Courier, monospace; font-size: small;"></pre>
</div>Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-73186972885654262532013-05-20T23:50:00.005-07:002013-05-20T23:50:45.482-07:00Возможности SharePoint разных версий и SharePoint Online<div dir="ltr" style="text-align: left;" trbidi="on">
Две полезные ссылочки, где гораздо понятнее и чётче расписаны возможности SharePoint разных версий и SharePoint Online<br />
<br />
<a href="http://www.khamis.net/blog/Lists/Posts/Post.aspx?ID=98">SharePoint 2013 On-Premises vs. Office 365 - SharePoint Online Key Feature Differences</a><br />
<br />
<a href="http://www.khamis.net/blog/Lists/Posts/Post.aspx?ID=96">SharePoint 2013 Standard vs. Enterprise vs. Foundation Feature Comparison Matrix</a></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-44032665246593297492013-05-07T04:52:00.000-07:002013-05-07T04:52:01.412-07:00Баги с лайками в SharePoint 2013<div dir="ltr" style="text-align: left;" trbidi="on">
<div lang="ru" style="font-family: Calibri; font-size: 11.0pt; margin: 0in;">
Интересно, как Microsoft тестируют продукт перед выпуском? </div>
<div lang="ru" style="font-family: Calibri; font-size: 11.0pt; margin: 0in;">
<br /></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">Создаём обсуждение</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4K5DrmyfcFi4jqL0WRXKEinwUhKlE7Xno3CUqLCXvyqdOe7HNeCZ9AR2qE6LTNxsEW4GzKP44EF4CgnLGkISmtrLVruyKjn6Ik3g_pneneudZBiSY4JP3Zrugye0hrJYC3ZXjVnbExZc/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4K5DrmyfcFi4jqL0WRXKEinwUhKlE7Xno3CUqLCXvyqdOe7HNeCZ9AR2qE6LTNxsEW4GzKP44EF4CgnLGkISmtrLVruyKjn6Ik3g_pneneudZBiSY4JP3Zrugye0hrJYC3ZXjVnbExZc/s1600/1.jpg" /></a></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;"><br /></span></span></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">лайкаем его, F5</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR_tPgGHNI4QBJ-HTDS5SNBhPzNgpMSt7PKVBwk7EX_NwNopfPvIhnY0tIsI-CAJvU9TJVmkstIlHNkf34o1c5ZPKCl6UiDJlTb6ZqOleeF_Nc2My568AZt_9wrX0_MBE-mWgxv0AmHC4/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR_tPgGHNI4QBJ-HTDS5SNBhPzNgpMSt7PKVBwk7EX_NwNopfPvIhnY0tIsI-CAJvU9TJVmkstIlHNkf34o1c5ZPKCl6UiDJlTb6ZqOleeF_Nc2My568AZt_9wrX0_MBE-mWgxv0AmHC4/s1600/2.jpg" /></a></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;"><br /></span></span></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">дизлайкаем его, F5</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWyKar4-jn7QkWN5mb2Ud-_5O0e4u3t-DWJad70FtDRLl0ruIjo6gTyXfFMy0b1OTTrkMg6AVGV62NOWZoi-35firPxqUBnp04zNl0nJDyAjBhfp_Og6_hgTz3kGeG8x6cTfB1EYU7uU/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWyKar4-jn7QkWN5mb2Ud-_5O0e4u3t-DWJad70FtDRLl0ruIjo6gTyXfFMy0b1OTTrkMg6AVGV62NOWZoi-35firPxqUBnp04zNl0nJDyAjBhfp_Og6_hgTz3kGeG8x6cTfB1EYU7uU/s1600/3.jpg" /></a></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;"><br /></span></span></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">Баг: 1 пометка "Нравится". Откудова, а?! Я же дизлайкнул!</span></span></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">лайкаем его, F5</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPq2lHkZu_TnWwmYFL_9sNM0nlXgAi-gXC-KEPRld0UsRtOZAvETBTApodFmBxGLaGcOz-vO-mWTlHDX9h88V1nlwxjAG-wvYvv2QZUHah9c4YD4ULuG8fCW99n6V-QOcuovsZvIAvA9Q/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPq2lHkZu_TnWwmYFL_9sNM0nlXgAi-gXC-KEPRld0UsRtOZAvETBTApodFmBxGLaGcOz-vO-mWTlHDX9h88V1nlwxjAG-wvYvv2QZUHah9c4YD4ULuG8fCW99n6V-QOcuovsZvIAvA9Q/s1600/4.jpg" /></a></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;"><br /></span></span></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">Баг: уже 2 пометки "Нравитися". Можно два раза лайкать?</span></span></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;">дизлайкаем его, F5</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD5n21JgSfY8F1xEvwnIoWb-eCef4aBKidhGD5pFDTplZvlsnL5QbjY-ShRQBURnQkp23YZPbfazq74SDlg7W7JBfB9hyphenhyphenlRge_8d1h5hRAE6iX2BKygD5s2pfE001kl8ofvuKaVZ_XI3M/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD5n21JgSfY8F1xEvwnIoWb-eCef4aBKidhGD5pFDTplZvlsnL5QbjY-ShRQBURnQkp23YZPbfazq74SDlg7W7JBfB9hyphenhyphenlRge_8d1h5hRAE6iX2BKygD5s2pfE001kl8ofvuKaVZ_XI3M/s1600/5.jpg" /></a></div>
<div lang="ru" style="margin: 0in;">
<span style="font-family: Calibri;"><span style="font-size: 15px;"><br /></span></span></div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-39687928906891648002013-05-06T12:56:00.001-07:002013-05-06T12:56:57.502-07:00Первая помощь<div dir="ltr" style="text-align: left;" trbidi="on">
Кто обязан оказать первую помощь:<br />
- госслужащий в форме (полицеский, врач, охранник, сварщик и кто угодно);<br />
- любой водитель (да, читайте законы внимательно).<br />
<br />
<b>Алгоритм.</b><br />
<b>Первичный осмотр:</b><br />
1. Мне что то угрожает? (Да -> уходите)<br />
2.1. Чел сам попросил<br />
2.2. Чел валяется без сознания, проверяем:<br />
- окрикнуть<br />
- потрясти<br />
- сделать ему больно (костяшками пальцев по грудине, сжать трапецивидную мышцу за шеей, сжать губу под носом...)<br />
2.2.1. Заглянуть в рот, очистить содержимое рта:<br />
Запрокиньте челу голову назад. Указательные пальцы на челюсть снизу, где скулы. Большие бальцы на подбородок. Открывает рот, потянув чуть на себя челюсть. Не выньте челюсть =) Двумя пальцами вынимаем содержимое (блевотину)) ) изо рта (чтоб мог дышать, иначе помрёт).<br />
2.2.2. Проверить дыхание<br />
- глазами, движение воздуха<br />
- запах<br />
- почувствовать рукой на грудной клутке<br />
Пульс мерять не нужно - не умеете и потеряете время. Дыхание = пульс!<br />
Нет дыхания -> немедленно СЛР.<br />
3. Вызвать скорую - 03.<br />
<br />
Обращаем внимание на пункт 3 - чем раньше вызовете скорую, тем лучше, лечить и спасать, просьба, после вызова скорой!<br />
<br />
Отгоните людей с нашатырём! Нашатырь дают только <b>в предобморочном</b> состоянии <b>с 30-40 сантиметров</b>. Он сжигает слизистую носа, это вызывает боль, это вызывает адреналин, он расширяет сосуды, кровь начинает ходить лучше - пациент не теряет сознание. Пациенту без сознания вы только сожжёте нос, так как боли он не чувствует, ну и лечиться он будет ещё и от ожога слизистой.<br />
<br />
Обморок - если чел свалился <b>при вас</b>. Если никто не видел как он упал, лечить от обморока нельзя, даже опасно, можно убить. Если чел свалился при вас, то полождите на землю, поднимите ноги. Кровь к голове придёт и через 15-30 секунд чел очнётся. Если был не обморок, а сердечный приступ, то вы его убили, +1.<br />
<br />
<b>Вопросы от скорой.</b><br />
Всегда такие, не психуйте и не спешите.<br />
1. Пол:<br />
- мужской<br />
- женский<br />
- иное (ага, есть такое, дети до 1 года)<br />
2. Возраст:<br />
- младенец<br />
- ребёнок<br />
- подросток<br />
- молодой человек<br />
- средних лет<br />
- пожилой<br />
- очень пожилой<br />
Возраст влияет на бригаду медиков и тулзы, которые они с собой захватят!<br />
3. Что случилось?<br />
"Не вася много пил, его бросила жена, которая родила пятерых детей, уехавших за границу и не присылающих открытку бедной матери, которая с горя начала пить и порезала палец, когда дядя ваня смотрел футбол..." а "упал, без сознания". Что случилось - это не история жизни, а состояние человека, что с ним произошло в последнюю минуту.<br />
4. Адрес<br />
5. Опционально: Кто вы?<br />
6. Опционально: Было ранение? (приедет милиция)<br />
7. Телефон, можно мобильный. Да, у всех скорых есть мобильники!<br />
"Вызов принят, ждите"<br />
<br />
<b>Вторичный осмотр:</b><br />
1. МЧС (мужики, чего случилось) - потом расскажете скорой, толпа будет тупить и нихрена не сможет сказать.<br />
2. Осмотр тела. Очень просто, как в американских фильмах про копов - кладёте руки по краям тела, начиная с плеч, и ведёте их вниз. Тело симметрично, если что-то есть с одной стороны, а с другой стороны нет - значит проблема, запоминаете и не лезете туда! Дождитесь скорой!<br />
<br />
<b>Перевести в востановительное состояние. </b><br />
Иначе язык западёт и чел задохнётся, так как даже в сознании запавший язык не вынуть. Восстановительное состояние - лёжит на богу, верхняя нога согнута в колене, нижняя рука вытянута в сторону взгляда, верхняя рука согнута и подложена под голову или плечо (не даёт челу скатиться на пузо).<br />
<br />
<br />
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-12973465734254400632013-04-30T06:52:00.001-07:002013-04-30T06:52:43.299-07:00В TFS 2012 не работает "Open in Microsoft Excel" в Office 2013<div dir="ltr" style="text-align: left;" trbidi="on">
Проблема обычно лечилась переустановкой "Microsoft Office Developer Tool for Visual Studio 2012".<div>
Но в этот раз ничего не помогало. Даже когда просто запускал Excel я не видел вкладки "TEAM". Но вручную, после активации add-in в FILE\Options\Add-ins manaege COM add-ins, появлалсь до следующего запуска Excel. </div>
<div>
Лечется легко, нужно добавить этот add-in в автозапуск. Через реестр это делается так:</div>
<div>
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\TFCOfficeShim.Connect.4\LoadBehavior значение 3</div>
</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-70106985032297143692013-04-15T13:18:00.000-07:002013-04-15T13:18:03.318-07:00Замена утконосу<div dir="ltr" style="text-align: left;" trbidi="on">
Сговнился утконос, начал искать замену. Тут как раз у Тёмиы проскочил пост, в итоге обновил свою карту магазинов. Магазины с доставкой еды там справа сверху. Единственное но - я не знаю ничё, кроме утконоса.<br />
<br />
<a href="http://www.mindmeister.com/266146035/_">http://www.mindmeister.com/266146035/_</a><br />
<br /></div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com0tag:blogger.com,1999:blog-8708056992412254343.post-21619672874848108492013-03-29T07:21:00.000-07:002013-03-29T07:22:27.807-07:00После мартовского обновления через Windows Update перестают работать Office Web Apps 2013<div dir="ltr" style="text-align: left;" trbidi="on">
Стоит только позавидовать качеству тестирования апдейтов от Microsoft.<br />
Если вы поставите мартовские апдейты на сервер, где хостится Office Web Apps 2013, то можете попрощаться с этим классным сервисом =)<br />
Предположительно это KB2760445 и KB2760486.<br />
<br />
<b>Симптомы:</b><br />
SharePoint, если подружен с Office Web Apps, перестаёт открывать документы в браузере.<br />
На сервере Office Web Apps процессор загружен на 100%.<br />
На сервере Office Web Apps в Event Logs появляется куча ошибок вроде этих:<br />
<br />
<i>Faulting application name: BroadcastWatchdog_App.exe, version: 15.0.4481.1000, time stamp: 0x50ee5a9f</i><br />
<i>Faulting module name: KERNELBASE.dll, version: 6.2.9200.16451, time stamp: 0x50988aa6</i><br />
<i>Exception code: 0xe0434352</i><br />
<i>Fault offset: 0x000000000003811c</i><br />
<i>Faulting process id: 0x132c</i><br />
<i>Faulting application start time: 0x01ce2c85c757619d</i><br />
<i>Faulting application path: C:\Program Files\Microsoft Office Web Apps\BroadcastServicesWatchdog_App\BroadcastWatchdog_App.exe</i><br />
<i>Faulting module path: C:\Windows\system32\KERNELBASE.dll</i><br />
<i>Report Id: 0592bc59-9879-11e2-93f6-005056884a14</i><br />
<i>Faulting package full name: </i><br />
<i>Faulting package-relative application ID: </i><br />
<i>---</i><br />
<i></i><br />
<i>Application: BroadcastWatchdog_App.exe</i><br />
<i>Framework Version: v4.0.30319</i><br />
<i>Description: The process was terminated due to an unhandled exception.</i><br />
<i>Exception Info: System.TypeInitializationException</i><br />
<i>Stack:</i><br />
<i> at Microsoft.Office.Web.Common.ServiceInstanceFinder.GetLocalAgentInstance(Microsoft.Office.Web.Common.OfficeServiceType)</i><br />
<i> at Microsoft.Office.Web.Common.WatchdogHelper.PrepareRegistrations(Microsoft.Office.Web.Common.OfficeServiceType)</i><br />
<i> at Microsoft.Office.Web.Common.WatchdogHelper.WatchMachines(Microsoft.Office.Web.Common.OfficeServiceType, CheckServiceInstance, Microsoft.Office.Web.Common.OfficeServiceType, System.String)</i><br />
<i> at Microsoft.Office.Server.Broadcast.Watchdog.BroadcastWatchdog_App.BroadcastWatchdog_App.Main()</i><br />
<i>---</i><br />
<br />
<i>Fault bucket , type 0</i><br />
<i>Event Name: CLR20r3</i><br />
<i>Response: Not available</i><br />
<i>Cab Id: 0</i><br />
<i><br /></i>
<i>Problem signature:</i><br />
<i>P1: diskcachewatchdog.exe</i><br />
<i>P2: 15.0.4481.1000</i><br />
<i>P3: 50ee5a78</i><br />
<i>P4: Microsoft.Office.Web.Apps.Environment.WacServer</i><br />
<i>P5: 15.0.4481.1001</i><br />
<i>P6: 50f900b0</i><br />
<i>P7: 60</i><br />
<i>P8: 9</i><br />
<i>P9: System.TypeInitialization</i><br />
<i>P10: </i><br />
<i><br /></i>
<i>Attached files:</i><br />
<i>C:\Windows\Temp\WERF163.tmp.appcompat.txt</i><br />
<i>C:\Windows\Temp\WERF164.tmp.WERInternalMetadata.xml</i><br />
<i>C:\Windows\Temp\WERF184.tmp.hdmp</i><br />
<i>C:\Windows\Temp\WERF03.tmp.dmp</i><br />
<i><br /></i>
<i>These files may be available here:</i><br />
<i>C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_diskcachewatchdo_f4542e69f36d5ae41063e952fa4d9d1994bd540_cab_0fb01077</i><br />
<i><br /></i>
<i>Analysis symbol: </i><br />
<i>Rechecking for solution: 0</i><br />
<i>Report Id: 0096f2ce-9879-11e2-93f6-005056884a14</i><br />
<i>Report Status: 4</i><br />
<i>Hashed bucket: </i><br />
<br />
<br />
<br />
<br />
<b>Как починить:</b><br />
Как всегда просто, нужно пересоздать ферму Office Web Apps - <a href="http://technet.microsoft.com/en-us/library/jj219436.aspx">New-OfficeWebAppsFarm</a><br />
Биндинги на SharePoint/Lync/Exchange пересоздавать не надо, если укажите тот же URL, что и раньше.</div>
Polyakovhttp://www.blogger.com/profile/10535784987076651271noreply@blogger.com1