Tips from the Team

Discussion List

• 
  Properly Identifying Identifiers

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  Display a Query Title in VSQL

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

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

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  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 2019Tips from the Team
• 
  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 2019Tips from the Team
• 
  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 2019Tips from the Team
• 
  Tracking the Current Transaction Start Date and Time

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

  Jim_Knicely 2K views 0 comments 1 point Most recent by Jim_Knicely March 2019Tips from the Team
• 
  Arithmetic Bit-shifting

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

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

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

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  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 2019Tips from the Team