Reputation
219
Next privilege 250 Rep.
View close votes
Badges
3 13
Newest
 Caucus
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Aug
30
asked Postgres 9.4 on kubuntu 14.04 won't start
Aug
3
awarded  Caucus
Aug
3
awarded  Constituent
Jul
22
awarded  Notable Question
May
20
accepted Optimize view (and underlying table) for averaging timestamps into hours
May
20
awarded  Curious
May
20
comment Optimize view (and underlying table) for averaging timestamps into hours
@ErwinBrandstetter 1. I brain farted the column name because that's what the data source called it. I can/will change that. 2. I subtract 5 minutes because I the average from x:05 to x+1:00 so I subtract 5 minutes so that when I truncate off the minutes all those times become the same value.
May
19
awarded  Commentator
May
19
comment Optimize view (and underlying table) for averaging timestamps into hours
@ErwinBrandstetter I added the missing index.
May
19
revised Optimize view (and underlying table) for averaging timestamps into hours
added index.
May
19
asked Optimize view (and underlying table) for averaging timestamps into hours
Apr
8
awarded  Popular Question
Mar
10
awarded  Popular Question
Feb
12
awarded  Nice Question
Feb
12
awarded  Yearling
Nov
9
awarded  Popular Question
Feb
24
revised Getting “Attempt to fetch logical page in database” error when running query
added 193 characters in body
Feb
24
comment Getting “Attempt to fetch logical page in database” error when running query
@AaronBertrand it was a clustered index. Not all queries fail like if I just do select top 5 * from 'table' that will work. I haven't looked at DBCC PAGE. I googled that and it looks like I need a filenum and pagenum but I don't know which ones to look at. I did run dbcc page(7, 1, 8687634, 3) and got Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Feb
24
comment Getting “Attempt to fetch logical page in database” error when running query
@Kin the msg is 605, level 21, state 3, line 1. I have SP1 right now but I'm downloading SP2.
Feb
24
revised Getting “Attempt to fetch logical page in database” error when running query
added 397 characters in body