|
"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 |
|
"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 |
|
"Select rows where the left key is less than the right key." in Enzee Universe • 2 replies |
1 day ago |
|
"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 |
|
"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 |
|
"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 |
|
"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 |
|
"Sounds like a bug in the emulator." in Users • 2 replies |
1 day ago |
|
"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 |
|
"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 |
|
"Have you generated statistics on the tables?" in Users • 9 replies |
6 days ago |
|
"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 |
|
"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 |
|
"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 |
|
"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 |