Search found 1800 matches

by JimKnicely
Mon Feb 05, 2018 9:58 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Default Size of the NUMBER Data Type
Replies: 0
Views: 264

Vertica Quick Tip: Default Size of the NUMBER Data Type

Vertica Community Blog post authored by Jim Knicely When creating a table where you do not define a precision for a NUMBER column data type, Vertica will use a default precision of 38 digits. Often this is larger than necessary. By specifying NUMBER(37) you will potentially get better query perform...
by JimKnicely
Mon Jan 29, 2018 4:50 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: A Truly Unique Constraint
Replies: 0
Views: 300

Vertica Quick Tip: A Truly Unique Constraint

Vertica Community Blog post authored by Jim Knicely According to the ANSI standards SQL:92, SQL:1999, and SQL:2003, a UNIQUE constraint should disallow duplicate non-NULL values, but allow multiple NULL values. A Unique Constraint in Vertica does just that! But what if I do not want to allow more t...
by JimKnicely
Fri Jan 26, 2018 2:26 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Generate a Random String
Replies: 0
Views: 250

Vertica Quick Tip: Generate a Random String

Vertica Community Blog post authored by Jim Knicely
You saw in a previous Vertica Quick Tip that you can create a SQL function that generates random dates. How about one that generates random strings?

Read more here:
https://forum.vertica.com/discussion/23 ... dom-string
by JimKnicely
Fri Jan 26, 2018 2:24 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Which rows will commit?
Replies: 0
Views: 250

Vertica Quick Tip: Which rows will commit?

Vertica Community Blog post authored by Jim Knicely Did you ever update a bunch of rows in a table, then forget which ones you changed? Fearing you might have updated an incorrect record, you might have to roll back and start again. Or, in Vertica you can first check which records have been modifie...
by JimKnicely
Fri Jan 26, 2018 2:23 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Date Arithmetic with Intervals
Replies: 0
Views: 217

Vertica Quick Tip: Date Arithmetic with Intervals

Vertica Community Blog post authored by Jim Knicely
In the last Vertica Quick Tip we saw how easy date arithmetic can be. Well, it can be even easier with Intervals!

Read more here:
https://forum.vertica.com/discussion/23 ... ertica-tip
by JimKnicely
Fri Jan 26, 2018 2:22 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Date Arithmetic in Vertica
Replies: 0
Views: 224

Vertica Quick Tip: Date Arithmetic in Vertica

Vertica Community Blog post authored by Jim Knicely
Date arithmetic in Vertica is extremely easy!

Read more here:
https://forum.vertica.com/discussion/23 ... in-vertica
by JimKnicely
Fri Jan 26, 2018 2:21 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets
Replies: 0
Views: 217

Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets

This blog post was authored by Jim Knicely. You can store billions and billions and billions (i.e., a lot) of records in your Vertica tables. When querying these large data sets, try to avoid using database functions like TO_DATE, TO_CHAR, NVL, etc. when unnecessary. Read more here: https://forum.v...

Go to advanced search