곰탱이의 개인블로그

Best Practices for Virtualizing and Managing SQL Server 2012

PDF

Best_Practices_for_Virtualizing_and_Managing_SQL_Server_2012.pdf

X1 Carbon Combo & Shortcut Keys

Lenovo x1 Function Key Combinations (Notebook)

F1 key when ThinkPad logo comes up, to enter the BIOS

Fn + F2 Lock your computer. Alternatively, a quick press of the power button will also lock your computer.

Fn + F3 Select a power plan that has been created by Power Manager, or adjust the power level by using the slider control.  Power Manager, allows power settings to be adjusted to give the best balance between performance and power saving.

Fn + F4 Put the notebook into sleep mode. To return from sleep mode, press the Fn key.

Fn + F5 Switch Wireless devices on/off.

Fn + F6 Launch the camera and audio settings window and the camera preview is turned on.  From this window, you can change the camera and audio settings.

Fn + F7 Switch between notebook screen and external display.

Fn + F8 Decrease display brightness.

Fn + F9 Increase display brightness.

Fn + F10 Previous track/scene.

Fn + F11 Play/Pause.

Fn + F12 Next track/scene.

Fn + Space Switch backlit keyboard On(low), On(High) and off.

Fn + P System

Fn + T Print Screen

Fn + B - Break

Fn + I - Insert

Fn + P - Pause

Fn + K - Screen Lock

Fn + S - system Request

https://www.youtube.com/playlist?list=PLs18hw3X0NC4p5ejzepofhi8x_L7aERCx

x1carbon_2_ug_en.pdf

Frequently used "ServerProperty"

SELECT

    SERVERPROPERTY('MachineName') AS [ServerName], 

SERVERPROPERTY('ServerName') AS [ServerInstanceName], 

    SERVERPROPERTY('InstanceName') AS [Instance], 

    SERVERPROPERTY('Edition') AS [Edition],

    SERVERPROPERTY('ProductVersion') AS [ProductVersion], 

Left(@@Version, Charindex('-', @@version) - 2) As VersionName

생각난김에 끄적 끄적.

예전에 다른 데엔 정리해 놨었는데...

지나다 보면 그런 질문 많이 받는다.

SQL Server 인덱스 생성일 언제인지 어떻게 알아요???

정답은 "PK 빼고는 모른다"이다.

1. PK는 다음과 같이 알 수 있다.

SELECT i.NAME 'Index Name' ,o.create_date

FROM sys.indexes i

INNER JOIN sys.objects o ON i.NAME = o.NAME

WHERE o.is_ms_shipped = 0

 AND o.type IN ('PK','FK','UQ')

 AND o.parent_object_id = (SELECT OBJECT_ID('테이블명'))

2. 다만, 인덱스통계작성일의 경우 다음 쿼리를 통해 확인이 가능하다.

--In SQL Server 2000

Select Name as IndexName,

STATS_DATE ( id , indid ) as IndexStatsDate

From sysindexes where id=object_id('HumanResources.Employee')

-- In SQL Server 2005

Select Name as IndexName,

STATS_DATE ( object_id , index_id ) as IndexStatsDate

From sys.indexes where object_id=object_id('HumanResources.Employee')

관련글 : http://judydba.tistory.com/788

그런 면에서 아래 글은 좀 희한한 내용일세...

http://www.sqlpanda.com/2013/10/how-to-check-index-creation-date.html

VMPlayer 4.x 대에서는

1. VMPlayer 설치파일이 있는 위치로 이동

2. VM~~.exe /e [압축해제할 위치]

3. network.cab의 압축을 해제

4. 압축해제한 파일 중 vmnetcfg.exe 파일 실행

이렇게 하면 되었지만,

VMPlayer 5.x 대에서는 이게 안된다.

다음과 같이 해야 함.

1. 관리자 계정으로 cmd 실행

2. VMPlayer가 설치되어 있는 폴더로 이동

  (ex. C:\Program Files (x86)\VMware\VMware Player )

3. 해당 폴더에서 다음 명렁어 실행

   rundll32.exe vmnetui.dll VMNetUI_ShowStandalone

4. 이제 네트워크 설정 가능

그렇군!

출처 : http://www.dbuggr.com/smallwei/quick-start-vmware-player-4-5-workstation-advance-networking-gui-tool/