The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Tips from the Team

Archives for October 2018

Re-Compute a Table Column’s Default Value

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Derive a Table Column’s Default Value from another Column

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Default a Column’s Value

Jim_Knicely 2.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display View Column Data Types

Jim_Knicely 2.2K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Insert Text Into Text

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Reset Your Session

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Conveniently Display Key Projection Info

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Checking the Validity of a Table Audit

Jim_Knicely 6.9K views 10 comments 1 point Most recent by Sankarmn May 2020Tips from the Team
Generate an Auto-Incrementing Alphabetical Series Using SQL

Jim_Knicely 1.2K views 0 comments 1 point Started by Jim_Knicely October 2018 Tips from the Team
Viewing Previously Generated Explain Plans

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display Null Query Result With an Alternate Text

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Special Date/Time Formatting

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Change the VSQL Result Set Border

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Find Which System Tables Have a Particular Column Name

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Find Which Tables Have a Particular Column Name

Jim_Knicely 1.9K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Database Storage - Raw and Compressed Size

Jim_Knicely 2.1K views 1 comment 1 point Most recent by yalin September 2020Tips from the Team
Display Last SQL Run Time

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Displaying the Administration Tools Process ID

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Rotating Column Data Using SQL Analytics

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Return Zero Instead of NULL

Jim_Knicely 1.5K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team

Tips from the Team

Discussion List