Tips from the Team

Archives for January 2019

Generate a Random Integer Within a Range

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Seeding a Random Integer

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Seeding a Random Number

Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Limiting the Amount of Memory Available to a Query

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Display a Rounded Number With a Specific Scale

Jim_Knicely 3.8K views 0 comments 1 point Most recent by Jim_Knicely January 2019Tips from the Team
View Vertica Features Recently Used

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Monitoring COPY Statement Events (Part 2)

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Monitoring COPY Statement Events (Part 1)

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Using VSQL as a Calculator

Jim_Knicely 1.6K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Extracting Characters from the Left and Right Side of a LONG VARCHAR

Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Determining the Current K-Safety

Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Specifying CASCADE When Dropping a Table

Jim_Knicely 2.4K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Ordering the List of Values Returned from LISTAGG

Jim_Knicely 3.7K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Ignore NULL Values in Non-Correlated Subqueries

Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Drop More than One Table at a Time

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Allowing Users to Query a View Owned by Another User

Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
A View Owner Needs Access to the Underlying Objects

Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Preserving Objects Owned by a Dropped User

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
List Table Rows by ROS Container

Jim_Knicely 3.6K views 2 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team
Tracking Save Points

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely January 2019Tips from the Team