Tips from the Team

Discussion List

• 
  Create a Python UDx to Order a List of Values

  Jim_Knicely 3.2K views 1 comment 1 point Most recent by bishal April 2019
• 
  Displaying the Vertica Code Name

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Forcing a Merge Join

  Jim_Knicely 3.1K views 0 comments 1 point Most recent by Jim_Knicely April 2019
• 
  Descending Sequences

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Display Session Sequence Cached Values Remaining

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Is this a Leap Year?

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  How Old Am I (In Months)?

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Display the Vertica Process Memory Allocated

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Display Database Statement Counts by Type

  Jim_Knicely 2K views 0 comments 1 point Most recent by Jim_Knicely April 2019
• 
  Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

  Jim_Knicely 3.5K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Truncating a Timestamp

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Accept the EULA When Installing Vertica

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely April 2019
• 
  Fun April Fool’s Day Trick Using Directed Queries

  Jim_Knicely 1.9K views 0 comments 1 point Most recent by Jim_Knicely April 2019
• 
  Properly Identifying Identifiers

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Display a Query Title in VSQL

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Run the Same Query Over and Over Again in VSQL

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Find out When Vertica was Last Updated

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

  Jim_Knicely 2.6K views 1 comment 0 points Most recent by Jim_Knicely March 2019
• 
  Using sed to Handle Empty String NULL Values Enclosed in Control Characters

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

  Jim_Knicely 3.2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Tracking the Current Transaction Start Date and Time

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Simple ASCII Charting Using SQL

  Jim_Knicely 2K views 0 comments 1 point Most recent by Jim_Knicely March 2019
• 
  Set All User’s Default Roles to All of their Granted Roles

  Jim_Knicely 3.8K views 1 comment 1 point Most recent by qinchaofeng March 2019
• 
  Arithmetic Bit-shifting

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Convert an Integer to a Binary

  Jim_Knicely 2.3K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Are These Two String Values Like Each Other?

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Identify a Tables Primary Key Columns

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Revoke Access to Multiple System Tables from Multiple Users with a New Role

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely March 2019
• 
  Revoke Access From Just One System Table

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019
• 
  Viewing Internal Statements Executed by Vertica

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019