Skip navigation

nickg

just joined the community
Login or Register to find out more about nickg
nickg has no profile image available
Status Level:
Active Enzee Active Enzee (326 points)
Member Since:
Mar 16, 2011
Groups:
Enzee Universe   Competitive Product Chat

Recent Activity

nickg replied to Using F5 load balance with NZ

"I'm sure the hardware sales guys love this one.  I've seen F5 used before to balance query loads and provide redundent fail over, just haven"

in TwinFin Talk 2 replies
12 hours ago
nickg replied to Groom is not releasing space

"That is the open question.  I don't know the internal mechanics Netezza goes through to maintain the query history log."

in TwinFin Talk 10 replies
16 hours ago
nickg replied to Unique Comparisons

"Select rows where the left key is less than the right key."

in Enzee Universe 2 replies
1 day ago
nickg replied to Looping in SQL

"Kimball used some shortcuts in his sample code.  As mentioned, he is using Oracle's recursive syntax built specifically for traversing a rec"

in TwinFin Talk 12 replies
1 day ago
nickg replied to Groom is not releasing space

"I'm not sure what p.xid refers to.  I was referring to the createxid of the row in the log.  It should match the rows in the table that was"

in TwinFin Talk 10 replies
1 day ago
nickg replied to Groom is not releasing space

"This came up before.   There is no direct way to find out, the system doesn't explicitly capture that information.  However, the transaction"

in TwinFin Talk 10 replies
1 day ago
nickg replied to Passwords

"Hmmm, too much information Shawn.  I think you just left a loaded gun in a monkey cage... "

in Enzee Universe 3 replies
1 day ago
nickg replied to Column reference "TABLE_NAME" is ambiguous

"Sounds like a bug in the emulator."

in Users 2 replies
1 day ago
nickg replied to ERROR [HY000] ERROR:  64004 : Column size limit exceeded

"A string is limited to 64000 bytes (either 64000 ASCII characters or 16000 UNICODE characters).  I believe there is also a total row width l"

in TwinFin Talk 3 replies
5 days ago
nickg replied to factrel planner not working

"One key rule in dimensional design is fact table foreign keys always reference a row.  It is standard practice to include 'unknown' rows in"

in Users 9 replies
5 days ago
nickg replied to factrel planner not working

"Have you generated statistics on the tables?"

in Users 9 replies
6 days ago
nickg replied to Start learning Netezza

"venky wrote:   Hi,   @Nick Galemmo: Thanks for the clarification then how would one practice nzsql?     Thanks Venky   The only way to u"

in Users 7 replies
6 days ago
nickg replied to Using nzsql command for sending partial output to a .dat file

"select statement from table B full outer join table B (self join comparing two enterits) -> of which output should go in .dat file.   Isn't"

in TwinFin Talk 2 replies
1 week ago
nickg replied to Swap partition event alert setup

"My guess is it would hit 100% and the query would blow up long before you notice the alert.  Besides, there isn't much you can do about it o"

in Users 4 replies
1 week ago
nickg replied to Start learning Netezza

"No.  NZSQL is implemented on the hardware.  There use to be a Netezza simulator (essentially an NZSQL emulator) that ran under Windows, but"

in Users 7 replies
1 week ago

Friends

    nickg currently has 1 friend.