Tips from the Team

Discussion List

• 
  Changing the Default Database Time Zone

  [Deleted User] 2.7K views 0 comments 0 points Most recent by [Deleted User] July 2018
• 
  Keepalive settings for AWS Network Load Balancer

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] July 2018
• 
  Counting Days, Week Days and Weekend Days Across the Years

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] July 2018
• 
  Synonyms

  [Deleted User] 2.4K views 0 comments 0 points Most recent by [Deleted User] July 2018
• 
  Changing the Data Type of a Column in an External Table

  [Deleted User] 2.7K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  NULL Equals NULL with NULLSEQUAL

  [Deleted User] 2.6K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Limiting a User’s Open Session Count

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Vertica Quick Tip: Handling NULL Equality in a WHERE Clause

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Faster CTAS Statements

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Analyze Statistics at the Schema Level (Part 2): Quick Tip

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Analyze Statistics at the Schema Level (Part 1): Quick Tip

  [Deleted User] 2.5K views 0 comments 1 point Most recent by [Deleted User] June 2018
• 
  Which One of these Nodes Doesn’t Belong?

  [Deleted User] 2K views 0 comments 1 point Most recent by [Deleted User] June 2018
• 
  Getting your Node Hardware Specs:

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Superfast Table Copy (Revisited)

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Monitoring Changes to Configuration Parameters

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] June 2018
• 
  Remove Duplicate Values from a String

  [Deleted User] 3.7K views 1 comment 0 points Most recent by Jim_Knicely June 2018
• 
  Empty String Vs. NULL

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

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

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

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] May 2018
• 
  Determining Table Columns that Contain NULL Values

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] May 2018
• 
  Getting Better Performance via External Table Row Counts

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] May 2018
• 
  Who am I?

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

  [Deleted User] 2.2K views 0 comments 1 point Most recent by [Deleted User] May 2018
• 
  Keeping DbVisualizer Alive

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

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] May 2018
• 
  Using vsql Almost Anywhere

  [Deleted User] 3.5K views 1 comment 0 points Most recent by Jim_Knicely May 2018
• 
  Get Rid of all Those Q’s

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

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

  [Deleted User] 2.1K views 0 comments 2 points Most recent by [Deleted User] May 2018