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
SELECT sp.stats_id, | |
name, | |
filter_definition, | |
last_updated, | |
rows, | |
rows_sampled, | |
steps, | |
unfiltered_rows, | |
modification_counter | |
FROM sys.stats AS stat |
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
SELECT 'ALTER INDEX [' + ix.name + '] ON [' + s.name + '].[' + t.name + '] ' + | |
CASE | |
WHEN ps.avg_fragmentation_in_percent > 15 | |
THEN 'REBUILD' | |
ELSE 'REORGANIZE' | |
END + | |
CASE | |
WHEN pc.partition_count > 1 | |
THEN ' PARTITION = ' + CAST(ps.partition_number AS nvarchar(MAX)) | |
ELSE '' |
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
SELECT OBJECT_NAME(dt.object_id) as [TableName] , --資料表名稱 | |
si.name as [IndexName] , --索引名稱 | |
dt.avg_fragmentation_in_percent, --邏輯片段的百分比 (索引中失序的頁面)。 | |
dt.avg_page_space_used_in_percent | |
FROM | |
(SELECT object_id , | |
index_id , | |
avg_fragmentation_in_percent, | |
avg_page_space_used_in_percent | |
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'DETAILED') |
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
SELECT S.name as 'Schema', | |
T.name as 'Table', | |
I.name as 'Index', | |
DDIPS.avg_fragmentation_in_percent, | |
DDIPS.page_count | |
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS DDIPS | |
INNER JOIN sys.tables T on T.object_id = DDIPS.object_id | |
INNER JOIN sys.schemas S on T.schema_id = S.schema_id | |
INNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id | |
AND DDIPS.index_id = I.index_id |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
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
/* | |
* Auto trigger an Auto Lookup every 10 seconds. | |
* 2018-Dec-07, Vincent Chu, AgilePoint Taiwan | |
*/ | |
// Wire round-robin schedule on form load completed. | |
eFormEvents.onFormLoadComplete = function () | |
{ | |
setInterval(TriggerPIRAutoLookup, 10000); | |
} |
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
#!/usr/bin/python | |
import sys | |
import time | |
import Adafruit_DHT | |
import requests | |
import json | |
def main(): | |
try: | |
while True: |
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
Usage ethminer [OPTIONS] | |
Options: | |
Work farming mode: | |
-F,--farm <url> Put into mining farm mode with the work server at URL (default: http://127.0.0.1:8545) | |
-FF,-FO, --farm-failover, --stratum-failover <url> Failover getwork/stratum URL (default: disabled) | |
--farm-retries <n> Number of retries until switch to failover (default: 3) | |
-S, --stratum <host:port> Put into stratum mode with the stratum server at host:port | |
-FS, --failover-stratum <host:port> Failover stratum server at host:port | |
-O, --userpass <username.workername:password> Stratum login credentials |
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
<html> | |
<head> | |
<link rel="stylesheet" href="Styles/font-awesome.min.css"> | |
<link rel="stylesheet" href="Styles/bootstrap.min.css"> | |
<link rel="stylesheet" href="Styles/jquery.json-viewer.css"> | |
<script src="/SharedResources/Javascript/jQuery/jquery-1.8.3.js"></script> | |
<script type="text/javascript" src="/SharedResources/Javascript/ExternalPlugins/cookies.js"></script> | |
<script type="text/javascript" src="/SharedResources/Javascript/ExternalPlugins/underscore.js"></script> | |
<script type="text/javascript" src="/SharedResources/Javascript/APPlugins/sessionManager.js"></script> |
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
<!DOCTYPE html> | |
<html xmlns="http://www.w3.org/1999/xhtml"> | |
<head> | |
<title></title> | |
<!--<script src="/SharedResources/Javascript/APPlugins/filemanager.js"></script>--> | |
<script type="text/javascript"> | |
document.write('<script type="text/javascript" src="/SharedResources/Javascript/APPlugins/filemanager.js?' + new Date().getTime() + '"><' + '/script>'); | |
</script> | |
<script> |
NewerOlder