#DateForumTypeThreadPost
611 Oct 2012 @ 05:52 PDTDatabaseReplyRE: Stats collection and PerformanceYes, over-collecting statistics can degrade performances, and surely will as they get outdated. The diagnostic helps you to see all column / column combinations that could be candidate for statis...
509 Oct 2012 @ 08:47 PDTDatabaseReplypartition questionTo answer the last question, if I get it right, NO RANGE is just another partition for any value out of the range you have defined. So partition elimination can also be leveraged for a value that i...
409 Oct 2012 @ 08:00 PDTDatabaseReplyPartition Elimination - Using Subquery RouteHi, There is no way the explain can predict the set of values returned by your subquery, so the partition elimination won't work here. However, this doesn't necessarily mean that the part...
308 Mar 2012 @ 12:23 PSTDatabaseReplyHandler for SQLException does not execute on SQL exception Hi, This very likely means that the code you are executing in the exception handler is failing at some point, before it reaches the END. This makes the procedure returning passing the "...
203 Mar 2012 @ 04:10 PSTDatabaseReplyAPI for DBC.SysExecSQL All the documentation is in the file mentionned by above by Jim. You cannot set or retrieve parameters (or result sets) using SysExecSQL(), by definition, this is only invoquing the SQL stat...
103 Mar 2012 @ 02:52 PSTDatabaseReplyExtracting text for macros, views and stored procedures Hi, Retrieving the code from dbc.tvm.CreateText, you will lose the formatting, comments and all the object names will be fully qualified. The overall won’t be really readable. Usin...