Tips from the Team

Announcements, news, and tips from Vertica employees.

Forcing a Merge Join

Jim_Knicely 2.1K views 0 comments 1 point Started by Jim_Knicely April 2019
Descending Sequences

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely April 2019
Display Session Sequence Cached Values Remaining

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely April 2019
Is this a Leap Year?

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely April 2019
How Old Am I (In Months)?

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely April 2019
Display the Vertica Process Memory Allocated

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely April 2019
Display Database Statement Counts by Type

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

Jim_Knicely 2.5K views 0 comments 0 points Started by Jim_Knicely April 2019
Truncating a Timestamp

Jim_Knicely 1.5K views 0 comments 0 points Started by Jim_Knicely April 2019
Partition a Table By More Than One Column

Jim_Knicely 2.2K views 0 comments 0 points Started by Jim_Knicely April 2019
Accept the EULA When Installing Vertica

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely April 2019
Fun April Fool’s Day Trick Using Directed Queries

Jim_Knicely 1.3K views 0 comments 1 point Started by Jim_Knicely April 2019
Properly Identifying Identifiers

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Display a Query Title in VSQL

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely March 2019
Run the Same Query Over and Over Again in VSQL

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Find out When Vertica was Last Updated

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

Jim_Knicely 1.7K 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 1.8K views 0 comments 0 points Started by Jim_Knicely March 2019
Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

Jim_Knicely 2.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Tracking the Current Transaction Start Date and Time

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Simple ASCII Charting Using SQL

Jim_Knicely 1.3K views 0 comments 1 point Started by Jim_Knicely March 2019
Set All User’s Default Roles to All of their Granted Roles

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

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Convert an Integer to a Binary

Jim_Knicely 1.5K views 0 comments 0 points Started by Jim_Knicely March 2019
Are These Two String Values Like Each Other?

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely March 2019
Identify a Tables Primary Key Columns

Jim_Knicely 1.8K views 0 comments 0 points Started by Jim_Knicely March 2019
Revoke Access to Multiple System Tables from Multiple Users with a New Role

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely March 2019
Revoke Access From Just One System Table

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely February 2019
Viewing Internal Statements Executed by Vertica

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely February 2019
Take a Peek at the Next Mergeout Job

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