#DateForumTypeThreadPost
616 Jun 2015 @ 02:26 PDTDatabaseReplyDBQL SQLTextInfo 3577: row size or sort key size overflowSame issue with TD14.  Character set was LATIN. Had a column that was VARCHAR(3000).  Using the below function gave error 3577: row size or sort key size overflow Solution: (cast t...
523 Jul 2014 @ 08:14 PDTDatabaseReplyResUsage Tables are not collecting dataPlease post the command you used to enable RSS..
423 Jul 2014 @ 04:33 PDTDatabaseReplySecondary index subtable If you don't have permissions to access the base table, ask the DBA to show the table and you will have the SI's columns. Assume you don't have select access on DBC.
323 Jul 2014 @ 04:30 PDTDatabaseReplyNeed help on a case scenarioNot sure the question.  You are joining table 1 to table 2 based on ID. Result should be ID 1 - 20*10  and ID 2 40*20.
223 Jul 2014 @ 08:13 PDTDatabaseReplySecondary index subtable If you show the base table, you will see the columns of the secondary indexes. UNIQUE PRIMARY INDEX PK_TEST_RESULTS ( TEST_PROC_ID ) UNIQUE INDEX ( PAT_ID ) INDEX ( RESULT_DATE ); &...
117 Jul 2014 @ 01:28 PDTDatabaseReplyHow to calulate Skew on Join IndexMany thanks to Dieter Noeth for his posts.  Your stats views have been outstanding. Minor change to code above.  I've been waiting weeks to get access to a customers QCD.  This ...