Tips from the Team

Discussion List

• 
  Take a Peek at the Next Mergeout Job

  Jim_Knicely 2.3K views 2 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Generate a Murmur Hash

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  View Tuple Mover Operation Run-time Intervals

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Auditing Flex Tables

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Tracking Table Row Counts Over Time

  Jim_Knicely 2.4K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Auditing Database DDL Operations

  Jim_Knicely 2.1K views 0 comments 1 point Most recent by Jim_Knicely February 2019
• 
  What’s the Distance Between Two Zip Codes?

  Jim_Knicely 4.9K views 2 comments 1 point Most recent by Jim_Knicely February 2019
• 
  Reset the ROUNDROBIN Load Balancing Counter

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Random Host Load Balancing

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Yet Another Way to De-Duplicate Table Rows

  Jim_Knicely 3.5K views 1 comment 1 point Most recent by mkheir February 2019
• 
  Combining Functions to Extract Discrete Data From a String

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Calculate a Year’s Chinese Zodiac Animal

  Jim_Knicely 2.1K views 1 comment 0 points Most recent by Jim_Knicely February 2019
• 
  Finding All Columns Storing Some Value

  Jim_Knicely 2.9K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Viewing External Table Definitions

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Generate a Random Integer Within a Range

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Seeding a Random Integer

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Seeding a Random Number

  Jim_Knicely 2.4K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Limiting the Amount of Memory Available to a Query

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Be Careful with the Sequence CACHE Value

  [Deleted User] 7.2K views 4 comments 0 points Most recent by sreeblr January 2019
• 
  Display a Rounded Number With a Specific Scale

  Jim_Knicely 4.7K views 0 comments 1 point Most recent by Jim_Knicely January 2019
• 
  View Vertica Features Recently Used

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Monitoring COPY Statement Events (Part 2)

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Monitoring COPY Statement Events (Part 1)

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Using VSQL as a Calculator

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Extracting Characters from the Left and Right Side of a LONG VARCHAR

  Jim_Knicely 2.8K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Determining the Current K-Safety

  Jim_Knicely 2.3K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Specifying CASCADE When Dropping a Table

  Jim_Knicely 2.9K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Ordering the List of Values Returned from LISTAGG

  Jim_Knicely 4.2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Ignore NULL Values in Non-Correlated Subqueries

  Jim_Knicely 2.3K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Drop More than One Table at a Time

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely January 2019