@MikeAsdf I've seen it as a pattern for data load where time was very critical. It pre-allocated all the disk and structures so we wouldn't have that overhead at run time. The risk is with variable-length columns: if they overflow the pre-assigned amount you get extra IO; underflow and there's wasted space, with corresponding IO overhead. As a day-to-day technique on an otherwise unstressed system, not worth it. Do the INSERT & DELETE and reqular index maintenance.
@dezso I would find that perfectly reasonable. Perhaps, where access to the more sensitive bits of PII is involved, people might need to sign some kind of NDA (unless the notion was already mentioned in their contract anyway), but that would be it.
That said, in this case there's no company, there's a person and their personal website, so maybe there need to be special ways to handle access to PII in such cases.
random useful UI feature of the day: Google Drive predicts immediately (less than 0.1 seconds) after starting an upload an ETA of 1003 hours and 56 minutes
The SQL Server web edition is only provided by server providers.
Why we can not individually get this licence subscription? I would prefer to subscribe directly from Microsoft's website by monthly payment
This is the only commercial licence that indie game developers or programmers can afford....
On top of that it shows a ridiculous amount of ignorance towards the existing editions including the free developer edition which according to the OP is "out of his scope" and "costs astronomically" (at zero cost). — TomTom12 hours ago
I'm wondering if anyone can find the mistake in my SQL-Query which I can't seem to find.. Been starring at the same lines of code for like 2 hours and it's driving me nuts!
So, here's the query... (Quite long but hopefully it's readable..) I'm working in VBA connected to the DB hence the ComboBo...
@PaulWhite You cleaned the whole thing up, I'm fine with that, but I think I flagged the only possibly relevant comments on the whole mess where on the answer where I flagged it :)
select b.executionId, a.applicationId,COUNT(IF(a.executionResult='pass',1,null)) as pass,COUNT(IF(a.executionResult='fail',1,null)) as fail from executionresult a inner join testexecution b on b.executionId=a.executionId where b.executionStatus='InProgress' group by a.executionId,a.applicationId
As you can see, I am retrieving the executionID and applicationid I have another table testprecheck and there is a column called objectrunstatus and query is
select objectrunstatus from testprecheck where executionId= and appId=
In our application, they first retrieve the first query and store in a list and then they pass executionid and applicationid to another method to retrieve the object run status so if a list has n elements then n times the 2nd query will be executed this I think will effect the performance
I merged both the queries
select tpc.objectrunstatus,b.executionId, a.applicationId,COUNT(IF(a.executionResult='pass',1,null)) as pass,COUNT(IF(a.executionResult='fail',1,null)) as fail from executionresult a inner join testexecution b on b.executionId=a.executionId
left join testprecheck tpc on tpc.executionId=b.executionId and tpc.appId=a.applicationId
where b.executionStatus='InProgress' group by a.executionId,a.applicationId
I do not have suffiecient data in db so I can not check if the query is right or not can you verify please?
@SpringLearner And please make sure your desired result is clear. It would be great if you showed the result of the query you already have as well, so that the intended change is easier to understand.
@SpringLearner Then you may end up with a suggestion that would work for those four rows but not for some edge cases that you wouldn't be able to check at the moment. Just saying.
How can I convert a string to a double precision in PostgreSQL ?
I tried something like :
update points set latitude2 = cast(latitude as double) ;
where latitude is a string and latitude2 is a double. I just can't get it to work.
Any Postgres folk agree this is not 'too localized'? I don't want to reopen it myself because I answered it, but I think it's the right side of the line personally.
the Meetup email is sitting in my inbox I can't make up my mind if I should go
"Expect a single-track series of talks from carefully selected submissions, guaranteeing an interesting and stimulating day. The conference always attracts top speakers - last year we saw the UK Government’s CTO Liam Maxwell commence proceedings - so expect more first class presentations from the leading experts in their field."
would like to know more about speakers and topics :)
Can you please help me formatting the script.I am using html format and trying to send to my mail but I am not getting output to mail but I can send output as attachment and can you please help me with styling also.Thank you.I changed my original servernames.
Function AGS
[System.Reflection.Ass...
Is SQLFiddle still down? It's been down for me for ~18 hours - I'm trying to create an Oracle schema - even the most basic of tests fails. I can bring up the site - just no do anything.
@ypercubeᵀᴹ OK - thanks for that - it was in response to your comment on my post earlier today that prompted this - is there another site that would be recommended by the plurality of users here - sqlzoo for example?
Ok, https://livesql.oracle.com/ is amazing. Oracle's own superpowered sqlfiddle
What are you doing with that many rows in your output? — dezso4 hours ago
@dezso , they answered
OLAP workload. The selected rows are then sorted and a LIMIT is applied, but the slow part is the WHERE+GROUP BY which is why I want to focus on optimizing that. — SGr4 hours ago
@ypercubeᵀᴹ Yes, I had a reply using PostgreSQL for an Oracle question - removed the need to use CTEs - principle is the same, but couldn't find an Oracle instance. You told me that my post didn't answer the question and I replied that I would use SQLFiddle when it was back up. I now know that it probably won't be for a while, so I'll try this livesql thing and report back.
if this is your exact code, you forgot to put a space at the end of this line:
FROM [RFD_New].[dbo].[RfD_]" & _
How can I convert a string to a double precision in PostgreSQL ?
I tried something like :
update points set latitude2 = cast(latitude as double) ;
where latitude is a string and latitude2 is a double. I just can't get it to work.
Can you please help me formatting the script.I am using html format and trying to send to my mail but I am not getting output to mail but I can send output as attachment and can you please help me with styling also.Thank you.I changed my original servernames.
Function AGS
[System.Reflection.Ass...
