anydragon

MSSQL Table List Query

(10%) select name from sysobjects where type='U'
(13%) select * from information_schema.tables
(76%) select * from sys.tables

(10%) select name from sysobjects where type='U'

(13%) select * from information_schema.tables

(76%) select * from sys.tables

다른건 그냥 웹에서 찾아보고
CPU Core 갯수를 가져오면

sysctl hw.ncpu | awk '{print $2}'

1	sysctl hw.ncpu \| awk '{print $2}'

load Avg가 저 수치가 되면 모든 cpu의 core를 100% 사용하고 있다는 거…

Install-Module posh-git -Scope CurrentUser
Install-Module oh-my-posh -Scope CurrentUser

1 2	Install-Module posh-git -Scope CurrentUser Install-Module oh-my-posh -Scope CurrentUser

if (!(Test-Path -Path $PROFILE )) { New-Item -Type File -Path $PROFILE -Force }
notepad.exe $PROFILE

1 2	if (!(Test-Path -Path $PROFILE )) { New-Item -Type File -Path $PROFILE -Force } notepad.exe $PROFILE

admin 권한으로

Set-ExecutionPolicy -Scope LocalMachine -ExecutionPolicy RemoteSigned -Force

1	Set-ExecutionPolicy -Scope LocalMachine -ExecutionPolicy RemoteSigned -Force