mssql.txt 2018-02-05T15:07:51Z 2018-02-05T15:07:51Z <br/>SQL 2005 JDBC fix the resultset re-read throws exception problem. However, you need to use executeUpdate() for insert,update and delete instead of execute() for SQL 2005 JDBC, otherwise will throw exception on this.<br/><br/>Other that, statement.executeBatch() will throws exception: <a href="">[..]kid=e13a8009-7466-4803-ba19-6bfd4b5f8966</a> <br/><br/>New function of SQL server 2014, In-Memory Optimization tables, suppose to be faster? - <a href=""></a> MOT table also support native compiled query - <a href=""></a> , and lock free write? <a href=""></a> <br/><br/>From microsoft, Use the columnstore index to achieve up to 10x query performance gains over traditional row-oriented storage, and up to 7x data compression over the uncompressed data size. - <a href=""></a> <br/><br/>A tool from M$ to help sql server user to manage change of database: <a href=""></a> . Other similar product is DBGhost, also only work for SQL server <a href=""></a> <br/><br/>There is a free version of SQL server 2005 call SQL server express, which just like MSDE <a href=""></a> <br/><br/>Here is a comparison: <a href="">[..]le/ArticleID/49618/sql_server_49618.html</a> , may be we can use that instead of MSDE 2005 and discoutinue support of SQL server 2000 so that we can test one thing less? <br/><br/>Import CSV to SQL server - <a href="">[..]oad-comma-delimited-file-csv-in-sql.html</a> <br/><br/>Shriking DB cause performance problem... not sure how long this finding is hold - <a href="">[..]eases-fragmentation-reduces-performance/</a> <br/><br/><a href="">[..]ver-storage-internals-part-1-basics.aspx</a> <br/><br/>Get the metadata - <a href="">[..]-metadata-from-sql-server-catalog-views/</a> <a href="">[..]icrosoft-sql-server-metadata-developers/</a> <br/><br/>Date functions - <a href="">[..]roduction-to-sql-servers-date-functions/</a> <br/><br/>Enhancement of 2016 - <a href=""></a> <br/><br/>Tool to rescue sql server - <a href=""></a> <a href=""></a> <a href=""></a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2018-02-05T15:07:51Z misc.txt 2017-02-22T07:10:51Z 2017-02-22T07:10:51Z <br/>Few distributed SQL DB vendor information - <a href=""></a> <br/><br/>Approximation DB - <a href="">[..]e-200x-faster-without-having-to-pay.html</a> <br/><br/>Discuss and compare difference technology of querying journey(log) data - <a href="">[..]on-log-and-data-storage-query-techniques</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2017-02-22T07:10:51Z pgsql.txt 2016-10-18T17:41:16Z 2016-10-18T17:41:16Z <br/><a href="">[..]0/introduction-to-postgresql-pljava.html</a> <br/><br/>PostgreSQL schema is way fast and easy to change than MySQL, although maybe slower - <a href="">[..]grating-from-mysql-to-postgresql-slides/</a> <br/><br/> Subindexes that can save you space and make updates faster by reusing an existing multi-column index.<br/> Expression indexes that speed up queries with WHERE clauses matching a function of the columns instead of raw values.<br/> Partial indexes that are much smaller than a complete index because they don't contain data that the app doesn't care about.<br/><a href="">[..]l-indexing-tricks-that-surprise-everyone</a> <br/><br/>Experience sharing, stored proc is better? <a href=""></a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2016-10-18T17:41:16Z oracle.txt 2016-06-22T23:23:32Z 2016-06-22T23:23:32Z <br/>Some comment saying that you cannot complain oracle for non-standard setup... However, should I break anything else just to install oracle? Anyway, may be a useful resource of installing oracle cluster - <a href=""></a> <br/><br/>Oracle SQL links - <a href=""></a> <br/><br/>Pure java solution to full text search - <a href=""></a> <a href="">[..]nning-lucene-inside-your-oracle-jvm.html</a> <a href=""></a> <br/><br/>Oracle does allow definitions of user-defined types.Please see <br/><a href="">[..]er.111/b28286/sql_elements001.htm#i46376</a> <br/><br/>User-defined types can then be used for column definitions. See e.g. <br/>the fourth example given here <br/><a href="">[..].111/b28286/statements_7002.htm#i2062833</a> <br/><br/>Oracle also allows creation of a table based on one user-defined type, <br/>i.e. an "object table".<br/>See here <br/><a href="">[..].111/b28286/statements_7002.htm#i2159410</a> <br/><br/>User-defined types can be changed; see <br/><a href="">[..].111/b28286/statements_4002.htm#i2057828</a> <br/>Oracle even offers an option as to whether existing data in tables <br/>based on previous type definition is converted or not; see <br/><a href="">[..].111/b28286/statements_4002.htm#i2079300</a> <br/>There are a couple of pages in the Object-Relational Developer's Guide explaining the consequences, briefly...<br/><br/>Note: all links above are to Oracle 11g documentation, but many, if not all, of these features have been available since 9i.<br/><br/>row base permission - <a href="">[..]/oracle/virtual-private-database-oracle/</a> <br/><br/>How fetch size can affect performance - <a href="">[..]jdbc-performance-tuning-with-fetch-size/</a> <br/><br/>Recycle bin for Oracle 10g - <a href="">[..]ecycle-bin-in-database.html#.UNXprSUqthH</a> <br/><br/>Oracle won't put null in index... how can we find the column with issue out? - <a href="">[..]12/the-index-youve-added-is-useless-why/</a> <br/><br/>You can have java like stacetrace at PLSQL - <a href=""></a> <br/><br/>Need to be careful about using rownum to limit the result in oracle - <a href="">[..]racle-limit-returned-records-with-rownum</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2016-06-22T23:23:32Z sybase.txt 2015-08-28T10:19:53Z 2015-08-28T10:19:53Z <br/>If you get following exception with Sybase ASE drive:<br/><br/>'System.Reflection.TargetInvocationException, Msg=Exception has been thrown by the target of an invocation.<br/>Exception details: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Sybase.Data.AseClient.AseConnection' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'sybdrvado115a.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)<br/> at ?.AseGetDriverVersion(StringBuilder A_0, Int32 A_1)<br/> at Sybase.Data.AseClient.AseConnection.?()<br/> at Sybase.Data.AseClient.AseConnection..cctor()<br/> --- End of inner exception stack trace ---<br/> at Sybase.Data.AseClient.AseConnection..ctor(String connectionString)<br/><br/>Please make sure the program can see sybdrvado115.dll, msvcp71.dll and msvcr71.dll in that same directory<br/><br/><a href=""></a> <br/><br/>===================<br/><br/>Query to check blocking at sybase: <br/>select spid,suser_name(suid),cmd,status,blocked,time_blocked,physical_io from master..sysprocesses where blocked <> 0<br/><br/><br/><br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2015-08-28T10:19:53Z mysql.txt 2014-05-26T07:30:30Z 2014-05-26T07:30:30Z <br/>It is surprising for me that it is this easy - <a href=""></a> <br/><br/>MySQL Proxy for table partition - <a href=""></a> <a href=""></a> <a href=""></a> <br/><br/>NoSQL way to access data in MySQL - <a href="">[..]0/10/using-mysql-as-nosql-story-for.html</a> <br/><br/>The lock level of mysql - <a href="">[..]ql-transaction-isolation-levels-and.html</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2014-05-26T07:30:30Z oracle cookbook.txt 2008-01-30T09:24:04Z 2008-01-30T09:24:04Z <br/>After default install of oracle at win32, here is the step of creating user:<br/><br/>1) sqlplus /noloh (enter sqlplus shell without login)<br/>2) connect oracle/oracle as sysdba (super user connection)<br/>3) CREATE USER CITY IDENTIFIED BY city DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT ACCOUNT UNLOCK;<br/>4) GRANT "CONNECT" TO CITY;<br/>5) GRANT "RESOURCE" TO CITY;<br/>grant dba to CITY;<br/><br/>-- Grant/Revoke system privileges <br/>grant create view to CITY;<br/>grant unlimited tablespace to CITY;<br/><br/>imp CITY/city full=y file=c:\xxxxx.dmp<br/><br/>6) sqlplus city (try login)<br/><br/>About create table space<br/><br/>create tablespace TBL01 datafile 'H:\oracle\oradata\ora9\TBL01.dbf' size 50M extent management local segment space management auto;<br/><br/>Other useful views<br/>1) sys.dba_tablespaces;<br/>2) sys.dba_users<br/>3) v$database<br/>4) dba_data_files<br/>5) v$datafile<br/><br/>Start and stop oracle batch <br/>net start OracleCSService<br/>net start OracleDBConsole[db name]<br/>net start OracleOraDb10g_home1iSQL*Plus<br/>net start OracleOraDb10g_home1TNSListener<br/>net start OracleService[db name]<br/><br/>net stop OracleCSService<br/>net stop OracleDBConsole[db name]<br/>net stop OracleOraDb10g_home1iSQL*Plus<br/>net stop OracleOraDb10g_home1TNSListener<br/>net stop OracleService[db name]<br/><br/>An useful link: <a href=""></a> <br/><br/>How to install oracle in Redhat 9 - <a href=""></a> <br/><br/>Check store procedure issues: select * from user_errors<br/><br/>If there is join like a.column1 = b.column2, and column1 in DATE datatype while column2 is VARCHAR2 datatype, oracle will auto-cast it in JDeveloper, but always return false if I call that stored procedure using JDBC.<br/><br/>Show plsql function detail implementation: select text from user_source where name = MY_PROCEDURE order by line; - <a href=""></a> <br/><br/>It is possible to get NullPointerException from oracle driver with IBM JDK... it look like IBM issue - <a href="">[..]s/forums/message.jspa?messageID=13980641</a> <br/><br/>plsql result caching - <a href="">[..]ed-up-database-code-with-result-caching/</a> <br/><br/>Oracle date foramt - <a href=""></a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src=""></script> 2008-01-30T09:24:04Z