http://www.sqlnotes.info/2011/10/24/locking-and-blocking-5-lock-resources-in-extended-events/
right('0X00EE00',2) 1자 초과로 읽을떄 처음 읽는 값이 null이믄 제외하고 읽더라고
SELECT *,%%lockres%%,SYS.FN_PHYSLOCFORMATTER(%%PHYSLOC%%) [FILEID:PAGEID:SLOTID],SYS.FN_GETROWSETIDFROMROWDUMP(%%ROWDUMP%%),%%rowdump%% partionid FROM DBO.TEST;
by 안인옥~