« first day (816 days earlier)      last day (4349 days later) » 

dezso
dezso
11:10
does anybody see questions on the DBA opening page?
Marian
Marian
yep
screencast.com/t/vGZnZ641
I remember someone else complained about questions missing from the homepage..
ypercube
ypercube
Phil did, yesterday. It appears that it happens from time to time.
dezso
dezso
Now I see them, too
Marian
Marian
11:25
0
Q: Database Already Prepared

mariosi don't know if here is the right place to ask this. I am searching for a database with German Restaurants for a web portal i am creating. Any proposals for a professional solution?

database-recommendation
off topic :)
vtc please, I know @ypercube already did :)
dezso
dezso
done. However, the content would be interesting to me :)
Marian
Marian
@dezso How's life in Berlin now? Getting any better?
dezso
dezso
anyway, as there are at least six or seven reastaurants just in this street, it would be a bit too much to digest :)
Life has been always superb, but now we have a flat to live in, that is an improvement
The snow (or the ice into which it turned) still fights for survival
Marian
Marian
How's the wife handling the move? :)
dezso
dezso
but the wheather is getting warmer every day (by a modest half degree approx.)
she is coming today
Marian
Marian
11:33
sounds good, preparing for spring then.. :)
dezso
dezso
but should be allright
ypercube
ypercube
We had 20 C yesterday
Marian
Marian
@ypercube I'm getting envious.. but only until June or something :)
dezso
dezso
probably the crisis creates warmth - the same in Portugal, I know and Cyprus and...
Marian
Marian
after that you have too high temps
dezso
dezso
11:35
so you are still experiencing wintery times?
ypercube
ypercube
@Marian Yes, June-August is too hot to stay in Athens. I happily live in the suburbs, which is slightly better. And last year I managed to be in the mountains for about 2 months :)
Marian
Marian
I'm in Bruges now, about 4-5 C..no snow. But in Ro it's a bit colder, so yeah, winter didn't go away.
dezso
dezso
Ah! So you could jump over here going back home (if you plan so :)
Marian
Marian
@ypercube 2 months? wow.. vacation or also work? :)
ypercube
ypercube
@Marian both
Marian
Marian
11:41
@dezso nah, everything is already set up. Don't really have much time free, employer is busting my arse :). My boss thought I looked too relaxed and now I'm getting some payback :D. If I have any free time I'm jumping to Amsterdam, though I doubt that too.
@ypercube I visited your country 2 times for vacation. Planning on a 3rd one. Still loving it. :)
ypercube
ypercube
@Marian You are equidistant from Amsterdam, Paris, London and Essen. Lots of choices for short-term visits.
Marian
Marian
@ypercube yep, true. In 'dam I have a close friend, that's why the bias.
 
5 hours later…
Jack Douglas
Jack Douglas
16:18
0
Q: Oracle trigger to update columns daily

chakrapsI'm trying to create a trigger that would run twice daily and do updates based on a specific condition. To be run on Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi We have Table A and Table B with columns Primary Key Date 1 Date 2 Date 3 Status For a specified set of Prima...

oracle oracle10g
one move vote to migrate this here anyone? ^^^^
 
5 hours later…
Marian
Marian
21:18
@JackDouglas A trigger to fire twice a day? Are you sure you want it here? :)
@JackDouglas LOL, the first answer comes from the same smart arse that accused Bluefeet of stealing his answer to that muddy question with changed Oracle versions. Not sure I want to see him on our site :-|.
proof here
Mar 27 at 15:18, by bluefeet
@ypercube I know it is just frustrating to have someone accuse you of stealing their answer.
 
2 hours later…
Simon Righarts
Simon Righarts
23:34
I just shrunk a database as an exigent solution to a space problem. I feel dirty. :-/
Simon Righarts
Simon Righarts
23:45
related: is it possible to do an online move of data from one data file to another? i.e. I have a 15GB data file on G:\ that I want to move to H:\ without the database going offline
Max Vernon
Max Vernon
you can alter index to move the clustered index to a different filegroup. If you have Enterprise Edition, you can do it WITH (ONLINE=ON) to do it without taking the table offline.
Simon Righarts
Simon Righarts
standard edition here, don't have the money for enterprise :p
Max Vernon
Max Vernon
ahh then you're out of luck doing it online.
you can recreate the table, copy the data, then rename the table to the name of the old table
ask the question on dba.se - you'll get lots of great answers
Simon Righarts
Simon Righarts
simpler solution: pick a database that no-one will notice is offline, then ninja-detach+copy+reattach ;)
Max Vernon
Max Vernon
yep, lol, the ninja option is always cool
Simon Righarts
Simon Righarts
23:58
until it blows up, yeah
Max Vernon
Max Vernon
really, it won't take long to move the data file if it's only 15gb... does it truly need to be online 24x7?

« first day (816 days earlier)      last day (4349 days later) »