« first day (1867 days earlier)      last day (3005 days later) » 

ypercubeᵀᴹ
ypercubeᵀᴹ
6:12 AM
@JamesLupolt no. He is talking BS.
Even with indexes, not all optimizers would be able to avoid a full index scan
 
 
2 hours later…
dezso
dezso
8:16 AM
2
Q: How to get max sequence of rows?

Yurii VasilchukI have a table with statistic of games which has next rows (I only write about rows that has interest in this context): id BIGINT PRIMARY KEY date TIMESTAMP WITH TIME ZONE status VARCHAR -- 'WON' or 'LOSE' player_id BIGINT -- FOREIGN KEY I need to write a query that select nu...

sql postgresql window-functions gaps-and-islands
shouldn't there be a canonical gaps-and-islands answer for every major RDBMS?
 
Andriy M
Andriy M
9:06 AM
 
Royi Namir
Royi Namir
9:25 AM
Hello. Our DBA told me that all statistics (count , cpu time etc) are deleted when the service is restarted.If so , how can I keep those statistics for future investigations? (SQL server 2008 R2)
It seems weird to me that it is deleted only because I had a problem and had to restart the service.
 
Tom V
Tom V
@RoyiNamir have a script that stores them in a database
 
Royi Namir
Royi Namir
And that script would run periodically via a JOB ?
 
Tom V
Tom V
yes
 
Royi Namir
Royi Namir
Ok thank you.
 
Tom V
Tom V
I'm about to head out, but look at this for an example (still useful when not using the dynamics stuff)
previous versions work on 2008 R2
 
 
13 hours later…
dezso
dezso
10:44 PM
Could you add an example about finding the entities and attributes? From their question, I think the OP lack a good understanding of these, so the example might be very helpful. — dezso 26 secs ago
so late, so constructive
my first reaction was to raise a NaA flag, then changed my mind
 

« first day (1867 days earlier)      last day (3005 days later) »