I initially thought you were on to something here. Working assumption was along the lines that perhaps the buffer pool wasn't immediately flushed as it requires "some work" to do so and why bother until the memory was required. But...
Your test is flawed.
What you're seeing in the buffer pool ...
I have a table that saves the size of file in the database when the user uploads it. I want to get the average value of all the size that the user uploaded.
I have the following column as example that shows the size in Mb's
|Size|
|1.20|
|0.25|
|0.50|
The result that I want as average is s...
I'm new to schema design in MongoDB.
How to design User schema in my web app. The web app allow users to create their account and login with their email address and password.
Also, there is an admin dashboard of the web app which can be accessed only by administrators. Admin will also use email...
I wanted to load data from PDF file to excel file using SSIS 2008 package. Can any one help me on this.
Thanks,
Venkat
No, not possible. Not sensible either. Broken design.
I was looking at the Pivot keyword in oracle
How is the pivot keyword implemented in Oracle?
How can I combine multiple rows into a comma-delimited list in SQL Server 2005?
Right now, I have a SQL Query like this one:
SELECT X, Y FROM POINTS
It returns results like so
X | Y
12 | 3
12 | 2
18 | 12
18 | 29
29 | 46
29 | 73
29 | 33
I'd like to return results like so:
X | Y...
Because somebody closed the question:
Implementation of Pivot keyword in oracle
SQL> EXPLAIN PLAN SET STATEMENT_ID = 'PIVOT' for
2 SELECT *
3 FROM EMP
4 PIVOT
5 (
6 SUM(EMP_ID) FOR f_name IN ('ankit', 'sumit', 'namit', 'manas')
7 );
Explained.
SQL> select * from tabl...
How can we search for a particular file in sub folders basing on the file name.
I have multiple sub folders and the file which i am looking for may present in the sub folder level or it may be present in sub folders under the present sub folder.
can any of you guys help me in this
I have a sub query that gets the top author by first name but since there can be more than 1 author, I want to concatenate the authors by ",". Would I need to use a case statement to check if there are more than 1 authors and then get the authors. How would I do that exactly?
The following is t...
I have a table in MySQL with following fields.
Date, block_no, entity, reading
Now I am firing this SQL and getting the results.
SELECT DATE,block_no,
SUM(IF(entity='KS',READING,0)) AS KS,
SUM(IF(entity='KB',READING,0)) AS KB,
SUM(IF(entity='V1',READING,0)) AS V1,
(SUM(IF(entity='KS',READIN...
I have a table that has an ID, a value, and a date. There are many IDs, Values, and dates in this table.
Records are inserted into this table periodically. The ID will always stay the same but occasionally the value will change.
How can I write a query that will give me the ID plus the most rec...
I'm porting an application I originally wrote to run on Apache using PHP and a MYSQL database. One of the queries used the MYSQL functions of Concat_WS and Group_Concat to first concatenate a few different columns into one string, and then concatenate all items that were grouped together by the G...
