-
编辑 删除
rebuild index online for SQL server
ALTER INDEX index_name ON table_nameREBUILD WITH (ONLINE = ON);
-
编辑 删除
make an index unusable
ALTER INDEX INDEX NAME UNUSABLE;
-
编辑 删除
Running Commands on a Remote Linux Server over SSH
http://www.shellhacks.com/en/Running-Commands-on-a-Remote-Linux-Server-over-SSH
-
编辑 删除
what shell I am in
echo $0
-
编辑 删除
How to find which process is holding certain port #
netstat -ap | grep <port #>
-
编辑 删除
改变从今天开始,立贴为证
坚定的完成计划
-
编辑 删除
how to create a table from select query in sql server
Select * into new_table from old_table
-
编辑 删除
svn revert to a previous revision
A very good description.https://aralbalkan.com/1381/http://svnbook.red-bean.com/en/1.5/svn.branchmerge.basicmerging.html#svn.branchmerge.basicmerging.undo
-
编辑 删除
JTA example
http://www.byteslounge.com/tutorials/spring-jta-multiple-resource-transactions-in-tomcat-with-atomikos-example
-
编辑 删除
XML CDATA
All text in an xml document will be parsed by the parser. But text inside a CDATA section will be ignored by the parser. A CDATA section starts with "<![CDATA[" and ends with "]]>"...
-
编辑 删除
show line numbers in vim
:set number or :set nu :set number! or :set nu!
-
编辑 删除
list open files
lsof
-
编辑 删除
Turn on or off syntax highlighting in vim
:syntax on :syntax off
-
编辑 删除
How to find final blocking session
SELECT s.sid, S.BLOCKING_SESSION, S.FINAL_BLOCKING_SESSION FROM v$session s WHERE s.blocking_session IS NULL AND exists( select 1 from v$session s2 where S2.BLOCKING_SESSION =...
-
编辑 删除
oracle Merge
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm MERGE INTO bonuses D USING (SELECT employee_id, salary, department_id FRO...
-
编辑 删除
How to back up partial data in a table
create table [tablename] asselect * from [another_TableName]
-
编辑 删除
how to resolve performance issue caused by locks
please refer to this following article, http://www.oracle.com/technetwork/issue-archive/2012/12-jul/o42dba-1566567.html How to find locked objects:1. Get row lock inf...
-
编辑 删除
How to find blocking sessions
please refer to the following article. http://www.oraclerecipes.com/monitoring/find-blocking-sessions/
-
编辑 删除
How to find the size of files and directories on linux
du -sh name where name could be the name of a file or the name of a directory
-
编辑 删除
zip and unzip
archive files or update files in an archive file: zip zipfile file1 file2 ... extract a file in an archive file: unzip zipfile fileToExtract eg. unzip wmserve...
