Tips from the Team

Discussion List

• 
  Extract Time from a Date

  [Deleted User] 5.7K views 2 comments 1 point Most recent by Jim_Knicely April 2018
• 
  Case-Insensitive Session Queries

  [Deleted User] 4.4K views 1 comment 0 points Most recent by Jim_Knicely March 2018
• 
  Parsing a String as Rows

  [Deleted User] 4.2K views 1 comment 0 points Most recent by KWillets March 2018
• 
  Expiring User's Password

  [Deleted User] 5.8K views 2 comments 0 points Most recent by Jim_Knicely February 2018
• 
  Superfast Table Copy

  [Deleted User] 8.9K views 4 comments 1 point Most recent by Jim_Knicely February 2018
• 
  Set a Client Connection Label

  [Deleted User] 4K views 1 comment 1 point Most recent by sKwa February 2018
• 
  .vsqlrc on Windows?

  marcothesane 4K views 1 comment 0 points Most recent by Jim_Knicely January 2018
• 
  Loading Genome data from sequencing system, illumine HiSeq Xs&2500.

  Kaito 4K views 1 comment 0 points Most recent by Moshe September 2017
• 
  Sampling data from a large dataset using TABLESAMPLE

  [Deleted User] 3K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  Getting a Word Count

  [Deleted User] 2.6K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Viewing Query Error Information

  [Deleted User] 2.8K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  vsql Shortcuts to Move Faster on the Command Line

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  Check the user role membership

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  What's the last day of the month?

  [Deleted User] 2.6K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  What's the first day of the month?

  [Deleted User] 5.9K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Keeping Track of Data Load Sources

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  What’s the Distance Between Two Points?

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Splitting a String into Rows

  [Deleted User] 4.9K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Repeating

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Default Size of the NUMBER Data Type

  [Deleted User] 2.6K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  Segmentation islands

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  Sorting IP addresses in Vertica

  [Deleted User] 2.4K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Truly Unique Constraints

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Date Arithmetic with Intervals: Vertica Tip

  [Deleted User] 2.7K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Date Arithmetic in Vertica

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Avoid Using Functions on Very Large Data Sets

  [Deleted User] 2.4K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Generating a Random Date

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Tip: How to Query for NaN Values

  [Deleted User] 3K views 0 comments 0 points Most recent by [Deleted User] January 2018
• 
  Understanding AT TIME ZONE

  [Deleted User] 3.6K views 0 comments 0 points Most recent by [Deleted User] March 2017
• 
  Filtering Data While Loading into Vertica

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] March 2017