Tips from the Team

Discussion List

• 
  Replacing an Empty String

  [Deleted User] 15.6K views 7 comments 0 points Most recent by Jim_Knicely November 2018Tips from the Team
• 
  Empty String Vs. NULL

  [Deleted User] 3K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Which Column in my Flattened Table caused the “Subquery used as an expression returned more than one

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Tuple Mover (TM) Assigned More Resources in Vertica 9.1

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Monitoring the Ancient History Mark

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Determining Table Columns that Contain NULL Values

  [Deleted User] 2.6K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Getting Better Performance via External Table Row Counts

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Remove Duplicate Values from a String

  [Deleted User] 4K views 1 comment 0 points Most recent by Jim_Knicely June 2018Tips from the Team
• 
  Who am I?

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  When Modifying a SEARCH_PATH, Don’t Forget to Include PUBLIC

  [Deleted User] 2.4K views 0 comments 1 point Most recent by [Deleted User] May 2018Tips from the Team
• 
  Keeping DbVisualizer Alive

  [Deleted User] 3.2K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Use the OVERLAY Function to Easily Insert a String Into Another String

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Eon Mode Now Available in Vertica 9.1

  [Deleted User] 9K views 5 comments 1 point Most recent by Jim_Knicely June 2019Tips from the Team
• 
  Using vsql Almost Anywhere

  [Deleted User] 3.7K views 1 comment 0 points Most recent by Jim_Knicely May 2018Tips from the Team
• 
  User-Defined Functions to the Rescue

  [Deleted User] 9.7K views 5 comments 0 points Most recent by Jim_Knicely July 2019Tips from the Team
• 
  Get Rid of all Those Q’s

  [Deleted User] 3.5K views 1 comment 0 points Most recent by Jim_Knicely May 2018Tips from the Team
• 
  Forget the Column Name in a System Table?

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] May 2018Tips from the Team
• 
  Capitalize Only the First Letter of Each Word

  [Deleted User] 2.2K views 0 comments 2 points Most recent by [Deleted User] May 2018Tips from the Team