67 reputation
17
bio website
location
age
visits member for 1 year, 10 months
seen Jan 20 at 9:44

Dec
17
comment What are the performance benefits of segregating database objects into different tablespaces?
Makes sense, I guess with cases like mine, it's more of a manageability choice, as you said it yourself
Dec
13
comment What are the performance benefits of segregating database objects into different tablespaces?
@MindaugasRiauba point taken
Nov
28
comment How does tablespace sizing works in Oracle
Another shameless bump on this
Nov
28
comment How does tablespace sizing works in Oracle
shameless bump on this
Nov
28
comment How does tablespace sizing works in Oracle
I think this site has a higher population compared to dbastackexchange which would yield me a faster response/answer, but if the mods would want to move my question there for the sake of segregation then I have nothing against that
Nov
16
comment Alternatives for UPDATE statement Oracle 11g
@Mat Sorry I had no idea that was illegal.
Feb
4
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
after reading some more stuff, you're right @Urban Doing table/data space separation on a single disk adds little value aside from fully utilizing multiple CPU cores (multi threading) and table partitioning which is a completely different concept.
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
This only answers a part of my question and not all of it. I still need to know what the measurable advantages are and what would the efficient logical design be, whether to segregate by database object type or by using business modules.. all of this using a single disk system. :/ @Urban
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
bumping on this
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
Again a very useful insight. Thanks @Urban
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
Very useful insight @Urban Björkman, but in terms of using a single disk, what other advantage can I expect if there are any?
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
okay now I'm confused.. what is the difference between table and data spaces? @marc_s
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
Thanks for the correction @RemusRusanu
Feb
1
comment What is the importance of customized data spaces in SQL Server and what are the quantitative measures that can be used to efficiently design this?
If in any case I have misunderstood any concept that I might have used above, please feel free to correct me
Jan
24
comment How to partition the table, week-wise?
yeah i just noticed the mysql tag, sorry about that lol