Viewing 15 posts - 1,156 through 1,170 (of 3,060 total)
Steve.hitch (2/25/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 25, 2011 at 11:21 am
abotha-1117340 (2/25/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 25, 2011 at 11:14 am
Rookie R (2/14/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 23, 2011 at 12:34 pm
FACT tables should store data at granular level, aggregations can be done either on-the-fly or in cubes for recurrent ones.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 22, 2011 at 12:31 pm
Stamey (2/21/2011)
Relational Model.
Interesting choice for a new Data Warehouse - nothing wrong about it, just interesting.
In this particular case basic indexing should include...
1- Unique indexes on all PK constraints on...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 21, 2011 at 5:52 pm
MonsterRocks (2/21/2011)
user_id int autoincrement primary key
user_name varchar(30) unique key
password varchar(30)
:
while login i checks
select * from ...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 21, 2011 at 2:35 pm
John.Liu (2/21/2011)
PaulB-TheOneAndOnly (2/20/2011)
I usually use syntax below...
if exists (select * from sys.tables where name like '#mytemptable%')
temp table is created in TEMPDB, unless you already in the TEMPDB, you have to...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 21, 2011 at 1:05 pm
May I ask how big is the database?
Also, may we know how much t-log gets generated per minute/hour/day?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 21, 2011 at 12:54 pm
sqlgreg (2/21/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 21, 2011 at 12:50 pm
diamondgm (2/20/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 20, 2011 at 5:34 pm
I usually use syntax below...
if exists (select * from sys.tables where name like '#mytemptable%')
drop table #mytemptable
create table #mytemptable(table definition as needed)
Please replace "mytemptable" with the appropriate name.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 20, 2011 at 5:10 pm
Just to rule out most likely suspects please check...
1- Query is written using four-parts-names.
2- There is an unique index on target table.
3- DTC is setup and running.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 20, 2011 at 4:56 pm
Please allow me to start one step before the indexing strategy.
What DWH model are you following? is it a Star schema or is it a Relational model?
For basic indexing,...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 18, 2011 at 4:23 pm
sqlgreg (2/17/2011)
I'm going to eat them. I find text files to be really delicious, with a bit of hot sauce.. 😛
Oh yes... I know what you mean, they are delicious...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 18, 2011 at 4:10 pm
Jo Pattyn (2/17/2011)
Apparently changed with oracle 10ghttp://decipherinfosys.wordpress.com/2007/04/28/writing-data-to-a-text-file-from-oracle/
This is one of those interesting scenarios where both of us are right.
I was right when I said "Oracle external tables are read-only -...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 18, 2011 at 4:06 pm
Viewing 15 posts - 1,156 through 1,170 (of 3,060 total)