Andy Cheng ccjeng

Talk is cheap. Show me the code.

ccjeng / gist:5394020

Created April 16, 2013 07:19

To resolve "An error occurred during decryption" issue, when migrating SQL server.

alter service master key force regenerate

ccjeng / gist:5308533

Last active December 15, 2015 19:08

PeopleSoft - Query to determine which records user can see

	SELECT DISTINCT B.TREE_NODE, Z.RECDESCR
	FROM PSTREEDEFN A,
	PSTREENODE B,
	PS_SCRTY_ACC_GRP C,
	PSTREENODE E,
	PSROLECLASS X,
	PSROLEUSER Y,
	PSRECDEFN Z
	WHERE A.SETID = ' '
	AND A.TREE_STRCT_ID = 'ACCESS_GROUP'

ccjeng / gist:5175351

Created March 16, 2013 07:11

SQL Server: get top 50 slow sql statement

	--get top 50 slow sql statement
	select top 50 * from
	(
	SELECT SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
	((CASE qs.statement_end_offset
	WHEN -1 THEN DATALENGTH(st.text)
	ELSE qs.statement_end_offset
	END - qs.statement_start_offset)/2) + 1) AS StatementText,
	last_execution_time as LastExecuted,
	last_elapsed_time/1000000.0 as ElapsedTimeInSeconds,

ccjeng / gist:5175340

Last active February 22, 2022 05:43

Android adb backup command

	## backup nonsystem apk
	adb backup -apk -shared -nosystem -all -f backup_apk.ab

	### backup system and nonsystem apk
	adb backup -apk -noshared -system -all -f backup_apk.ab

	## backup individual apk
	adb backup -apk com.example.testing -f testing.ab

	## restore all