10/27/2016
How to check progress of DBCC SHRINKFILE?
當我們在 SQL Server Management Studio 做 Database Shrink 時, 往往看不到 Progress.
原文請參考: 這裡!
下面這個指令, 可以讓我們看到 Progress.
原文請參考: 這裡!
下面這個指令, 可以讓我們看到 Progress.
select T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id)
, R.cpu_time, R.total_elapsed_time, R.percent_complete
from sys.dm_exec_requests R
cross apply sys.dm_exec_sql_text(R.sql_handle) T
10/25/2016
MSSQL 2005 Check Backup/Restore Progress
因為工作上需要, 有時候要 Restore SQL 2005 in command line mode.
底下的 Script 可以檢查大概的 progress.
相關資料請參考 這裡 .
底下的 Script 可以檢查大概的 progress.
相關資料請參考 這裡 .
SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete)
AS [Percent Complete],CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time],
CONVERT(NUMERIC(10,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min],
CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min],
CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours],
CONVERT(VARCHAR(1000),(SELECT SUBSTRING(text,r.statement_start_offset/2,
CASE WHEN r.statement_end_offset = -1 THEN 1000 ELSE (r.statement_end_offset-r.statement_start_offset)/2 END)
FROM sys.dm_exec_sql_text(sql_handle)))
FROM sys.dm_exec_requests r WHERE command IN ('RESTORE DATABASE','BACKUP DATABASE')
5/25/2016
Angular 學習筆記
need to install Node.js
and nvm is a good Node Version Manager tool
need to install npm - package manager
Install the Angular CLI - npm install -g @angular/cli
Angular 5 and ASP.NET Core
在 Windows 下, 執行 ng build, 出現
cannot be loaded because running scripts is disabled on this system. for more information
Open PowerShell with Administrator access rights
execute Set-ExecutionPolicy RemoteSigned
https://stackoverflow.com/questions/4037939/powershell-says-execution-of-scripts-is-disabled-on-this-system
Subscribe to:
Posts (Atom)