Viewing 10 posts - 1 through 10 (of 10 total)
I have some issues regarding speed and a ODBC conection to an Progress database.
I can't read anywhere that this solution is also availible for an Progress database.
Can...
August 28, 2017 at 5:20 am
So I created all the views and there working great (even query's that uses UNION ALL did not expect that :-)). However I came to the following and I am...
October 26, 2016 at 2:32 pm
First of all thanks for the answers.
We are doing the second database because we don't want our main database to be put in to use by other applications that our...
October 24, 2016 at 1:59 pm
Sweet article, currently I am figuring out what is the best option for the company where I work.
The SSIS package in use is not for a large datawarehouse structure or...
November 3, 2013 at 8:19 am
What do you mean by delta's?
And is it faster to camper if the row changed or just to reload the table?
Cause I got 2 fields I can check if there...
October 19, 2013 at 6:41 am
That could be an idea,
however I am not familiar with progress query writing and I always get an type collision...
Next to it the progress database is only a read only...
October 15, 2013 at 1:44 pm
I tried this solution on table with over 7 million results. (Around a 100.000 duplicates each) however the query did run for around 57 minutes then my server crashed and...
October 15, 2013 at 12:38 pm
Hmm sorry for the no reply busy times here...
For the fact, it aint an OLAP database it is our operational database. But since the last post I made the size...
October 15, 2013 at 12:22 pm
Result of sp_spaceused:
name
Table
rows
38131415
reserved
9961568
data
4952240 kb
index_size
5007848 kb
unused
1480 kb
Size reserved:
2140 byte
with:
SELECT
*
FROM
OPENQUERY (LinkedServer, 'select
*
from
PUB."Table"
where
"dd_sys-dat" = sysdate'
)
This query returns 62 rows and take up...
August 5, 2013 at 1:25 am
Thx for the deadlock tip. How can i Find THE size of a row? 🙂
August 4, 2013 at 10:33 am
Viewing 10 posts - 1 through 10 (of 10 total)