Anatoliy Sitnikov a-sitnikov
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Функция ВыполнитьЗапросADO(Соединение, ТекстЗапроса) | |
| НаборЗаписей = Соединение.Execute(ТекстЗапроса); | |
| ТаблицаДанных = Новый ТаблицаЗначений; | |
| Для Счетчик = 0 По НаборЗаписей.Fields.Count - 1 Цикл | |
| ТаблицаДанных.Колонки.Добавить(НаборЗаписей.Fields(Счетчик).Name); | |
| КонецЦикла; | |
| Если НЕ НаборЗаписей.EOF Тогда |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| &НаКлиенте | |
| Процедура КомандаПеребор(Команда) | |
| Значения = Новый Массив; | |
| Значения.Добавить("а"); | |
| Значения.Добавить("б"); | |
| Значения.Добавить("в"); | |
| МаксЗначение = Значения.Количество() - 1; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| &НаКлиентеНаСервереБезКонтекста | |
| Процедура УстановитьПометкуГруппы(Строка) | |
| ИтогоПометка = 0; | |
| Колво = 0; | |
| Строки = Строка.ПолучитьЭлементы(); | |
| Для каждого Строка1 из Строки Цикл | |
| Если Строка1.Пометка = 1 Тогда |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| &НаКлиенте | |
| Процедура Загрузить(Команда) | |
| ОписаниеОповещения = Новый ОписаниеОповещения("ЗагрузитьЗавершение", ЭтотОбъект); | |
| НачатьПомещениеФайлаНаСервер(ОписаниеОповещения,,,, ИмяФайла , УникальныйИдентификатор); | |
| КонецПроцедуры | |
| &НаКлиенте | |
| Процедура ЗагрузитьЗавершение(ОписаниеФайла, ДопПараметры) Экспорт |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| &НаКлиенте | |
| Процедура Сохранить(Команда) | |
| Адрес = СохранитьНаСервере(); | |
| Описание = Новый ОписаниеПередаваемогоФайла(Объект.ИмяФайла, Адрес); | |
| МассивОписаний = Новый Массив; | |
| МассивОписаний.Добавить(Описание); | |
| ПолучитьФайлы(МассивОписаний,,,Ложь); | |
| Состояние("Файл сохранен"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // ==UserScript== | |
| // @name ixbt | |
| // @namespace http://tampermonkey.net/ | |
| // @version 0.12 | |
| // @description try to take over the world! | |
| // @author You | |
| // @match http://www.ixbt.com/* | |
| // @grant none | |
| // @downloadURL https://gist.githubusercontent.com/a-sitnikov/8b250eaecfb5114e35c2b1c002397daa/raw/user.js | |
| // @updateURL https://gist.githubusercontent.com/a-sitnikov/8b250eaecfb5114e35c2b1c002397daa/raw/user.js |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| EXEC sp_configure 'show advanced options', 1 | |
| RECONFIGURE | |
| EXEC sp_configure 'xp_cmdshell', 1 | |
| RECONFIGURE | |
| EXEC xp_cmdshell "del /Q E:\Temp\erp.bak" | |
| EXEC sp_configure 'xp_cmdshell', 0 | |
| RECONFIGURE |
a-sitnikov
/ MissingIndex.sql
Last active
May 23, 2017 12:52
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx | |
| --http://infostart.ru/public/128175/ | |
| SELECT | |
| migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure, | |
| 'CREATE INDEX [missing_index_' + CONVERT (varchar, mig.index_group_handle) + '_' + CONVERT (varchar, mid.index_handle) | |
| + '_' + LEFT (PARSENAME(mid.statement, 1), 32) + ']' | |
| + ' ON ' + mid.statement | |
| + ' (' + ISNULL (mid.equality_columns,'') | |
| + CASE WHEN mid.equality_columns IS NOT NULL AND mid.inequality_columns IS NOT NULL THEN ',' ELSE '' END |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const Imap = require('imap'); | |
| let imap = new Imap({ | |
| user: 'user@mail.ru', | |
| password: 'pass', | |
| host: 'imap.mail.ru', | |
| port: 993, | |
| tls: true | |
| }); | |
| function imapConnect(imap) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cd /D "%~dp0" | |
| cscript.exe erp.js |