|
right('0X00EE00',2) 1자 초과로 읽을떄 처음 읽는 값이 null이믄 제외하고 읽더라고
SELECT *,%%lockres%%,SYS.FN_PHYSLOCFORMATTER(%%PHYSLOC%%) [FILEID:PAGEID:SLOTID],SYS.FN_GETROWSETIDFROMROWDUMP(%%ROWDUMP%%),%%rowdump%% partionid FROM DBO.TEST;
by 안인옥~
SELECT * FROM SYSOBJECTS WHERE NAME LIKE 'DM_XE_%' AND NAME NOT LIKE 'DM_XE_SESSION%'
GO
DECLARE @KEYWORD VARCHAR(100) = 'lock_escalation'
SELECT 'DM_XE_PACKAGES', * FROM SYS.DM_XE_PACKAGES WHERE NAME LIKE '%'+@KEYWORD+'%' OR DESCRIPTION LIKE '%'+@KEYWORD+'%'
SELECT 'DM_XE_OBJECTS',* FROM SYS.DM_XE_OBJECTS WHERE NAME LIKE '%'+@KEYWORD+'%' OR DESCRIPTION LIKE '%'+@KEYWORD+'%'
SELECT 'DM_XE_OBJECT_COLUMNS',* FROM SYS.DM_XE_OBJECT_COLUMNS WHERE NAME LIKE '%'+@KEYWORD+'%' OR DESCRIPTION LIKE '%'+@KEYWORD+'%'
SELECT 'DM_XE_MAP_VALUES',* FROM SYS.DM_XE_MAP_VALUES WHERE NAME LIKE '%'+@KEYWORD+'%' OR MAP_VALUE LIKE '%'+@KEYWORD+'%'
GO
SELECT P.NAME PACKAGE_NAME, O.NAME OBJECT_NAME, OBJECT_TYPE
, OC.NAME OBJECT_COLUMNS_NAME, CASE COLUMN_TYPE WHEN 'DATA' THEN '=' WHEN 'CUSTOMIZABLE' THEN '=(1)' ELSE '' END PREDICATE_SRC
, OC.TYPE_NAME OBJECT_COLUMN_TYPE_NAME, OC.COLUMN_TYPE OBJECT_COLUMN_TYPE
, MV.MAP_KEY MAP_VALUES_KEY, MV.MAP_VALUE MAP_VALUES_MAP_VALUE
FROM SYS.DM_XE_PACKAGES P
LEFT JOIN SYS.DM_XE_OBJECTS O
ON P.GUID = O.PACKAGE_GUID
LEFT JOIN SYS.DM_XE_OBJECT_COLUMNS OC
ON O.NAME = OC.OBJECT_NAME
AND O.PACKAGE_GUID = OC.OBJECT_PACKAGE_GUID
LEFT JOIN SYS.DM_XE_MAP_VALUES MV
ON (OC.OBJECT_PACKAGE_GUID = MV.OBJECT_PACKAGE_GUID AND OC.TYPE_NAME = MV.NAME)
OR (O.NAME = MV.NAME AND O.OBJECT_TYPE ='MAP')
WHERE
-- P.NAME = 'SQLOS'
--AND P.DESCRIPTION =''
--AND
O.NAME ='LOCK_ESCALATION'
--AND O.DESCRIPTION = ''
--AND OC.NAME = 'MAX_MEMORY_GRANT'
--AND OC.DESCRIPTION = ''
--AND MV.NAME = 'lock_escalation_cause'
--AND MV.MAP_VALUE = ''
ORDER BY
P.NAME
, O.NAME
, CASE OC.COLUMN_TYPE WHEN 'READONLY' THEN 1 WHEN 'CUSTOMIZABLE' THEN 2 WHEN 'DATA' THEN 3 ELSE NULL END
, OC.COLUMN_ID
, MV.NAME
, MV.MAP_KEY
netsh interface ip delete arpcache 로 되는게 아니구나....
http://support.microsoft.com/kb/196271/ko
http://esupport.trendmicro.com/solution/en-us/1036554.aspx
netsh winsock reset
To do this, perform the following:
|
1. |
Make sure that the latest patch for IWSS 2.5 is installed in your machine. |
|
2. |
Open the Registry Editor. |
|
Important: Always back up the whole registry before making any modifications. Incorrect changes to the registry can cause serious system problems. | |
|
3. |
Under the HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters hive, add the following "MaxUserPort" registry key with the following details: |
|
Data type: REG_DWORD Range: 5,000-65,534 (port number) Default value: 5000 | |
|
4. |
Set the value to "65530". |
|
5. |
Under the same hive, add the "TcpTimedWaitDelay" registry key with the following details: |
|
Data type: REG_DWORD Range: 0x0 0x12C (0-300 seconds) Default value: 0x78 (120 seconds = 2 min) | |
|
6. |
Set the value to "60". |
|
Note: These two keys do not exist by default. |
select who.[Current LSN], sl.name, cast(who.[Begin Time] as datetime) [Begin Time], what.Operation
, what.[RowLog Contents 0]
, what.[RowLog Contents 1]
, what.*
from fn_dblog (NULL, NULL) who
join fn_dblog (NULL, NULL) what
on left (who.[Current LSN], 17) = left (what.[Current LSN], 17)
join sys.syslogins sl
on who.[Transaction SID] = sl.sid
where who.Operation = 'LOP_BEGIN_XACT'
and what.PartitionId = (select partition_id from sys.partitions where object_id = object_id('student'))
and what.[Context] IN ('LCX_HEAP','LCX_CLUSTERED')
and cast(who.[Begin Time] as datetime) between '20000101' and '20200101'
http://www.sqlservercentral.com/articles/Transaction+Logs/71415/
http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/
http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-2/
아주 좋네요~
아래 2파일은 8.1 용이다.
아래 화면은 데탑에 다른 계정으로 노트북으로 mstsc 를 연결 했는데 데탑이 잠기지 않은 화면 입니다.
mstsc /multimon 은 여러모니터를 한번에 쓸 수 있다.
도메인을 정확히 로그인 해야 한다. -_-~ 음....win8\user
일자
10월 26일 오전 7시 30분 ~ 10월 27일 오전 10시
코스
용인 기흥 ~ 부산역
준비물
.... 글쎄~
동반자
상수 그리고.. ?
우린 성공했다...404 Km 무박 2일 (26시간)
http://www.endomondo.com/workouts/262267969?country=kr&lang=en&measure=metric&o=course&fb_source=708
건전지가 충분하지 않아 엔도몬도를 끝까지 찍지는 못했다. 충전속도보다 방전 속도가 더 빠름.......-_ -;;
script.txt
termsrv.dll_patched-win8.zip
