Viewing 15 posts - 331 through 345 (of 3,060 total)
S_Kumar_S (4/20/2012)
I was thinking if there can be some other way of handling this kind os scenario rather than putting everything in one transaction.
A transaction has to include everything that...
_____________________________________
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.April 20, 2012 at 6:35 am
ppcentral (4/19/2012)
If I have a fact table aggregated by...
Risking to start some kind of religious war here I would say that "facts" are by definition granular, nor aggregated. A FACT...
_____________________________________
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.April 19, 2012 at 5:45 am
Lynn Pettis (4/18/2012)
PaulB-TheOneAndOnly (4/18/2012)
Gazareth (4/18/2012)
Just had a 1.4TB, (whisper it) MySQL table become corrupt. Wonder how long the repair'll take? :crazy:
MySQL? do you realize this is the Oracle section...
_____________________________________
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.April 19, 2012 at 5:41 am
Gazareth (4/18/2012)
Just had a 1.4TB, (whisper it) MySQL table become corrupt. Wonder how long the repair'll take? :crazy:
MySQL? do you realize this is the Oracle section of a SQL...
_____________________________________
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.April 18, 2012 at 3:13 pm
ravi@sql (4/18/2012)
What are the different types of errors in sql server ?
Three categories...
1- "I do not give a rats a$$" kind of error (warnings)
2- "wtf?!" kind of errors (errors that...
_____________________________________
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.April 18, 2012 at 5:58 am
Dj463 (4/13/2012)
We are currently running SQL Server 2005, and i need to archive data from databases in Production server to another server. From the information that i gathered, Which one...
_____________________________________
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.April 18, 2012 at 5:55 am
daveap (4/17/2012)
SELECT waf.activity_count
...
_____________________________________
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.April 17, 2012 at 4:20 pm
Larry Page(Ehsan.Akbar) (4/16/2012)
Lynn Pettis (4/16/2012)
Depends, what is the purpose of this exercise? Is this for a class project?no it is a competition in our university.
Can you choose a different...
_____________________________________
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.April 16, 2012 at 4:05 pm
Larry Page(Ehsan.Akbar) (4/16/2012)
PaulB-TheOneAndOnly (4/16/2012)
Larry Page(Ehsan.Akbar) (4/16/2012)
Henrico Bekker (4/15/2012)
Yeah, dont think DM is the right tool for your game....
so my problem is which information should be inserted in my database as...
_____________________________________
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.April 16, 2012 at 4:03 pm
Oracle software is free for educational purposes so you are entitled to download and install Oracle on a home computer so to train yourself.
Oracle documentation is free and public, please...
_____________________________________
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.April 16, 2012 at 3:59 pm
Larry Page(Ehsan.Akbar) (4/16/2012)
Henrico Bekker (4/15/2012)
Yeah, dont think DM is the right tool for your game....
so my problem is which information should be inserted in my database as an input ?
this...
_____________________________________
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.April 16, 2012 at 8:46 am
Not much of a problem - I have a assortment of different versions of SQL Server, Oracle, PostgreSQL and MySQL on my personal laptop. I just make sure only one...
_____________________________________
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.April 15, 2012 at 5:19 pm
Larry Page(Ehsan.Akbar) (4/15/2012)
yes ,i work with sql server for data mining
Okay... please tell us which would be the target dataset you are planing to source from. Also, do you think...
_____________________________________
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.April 15, 2012 at 4:45 pm
Do you know what Data Mining is?
_____________________________________
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.April 15, 2012 at 1:52 pm
sukato7 (4/14/2012)
How can I set PK columns to allow null or blank?
You cannot do it.
A Primary Key is a Referential Integrity constraint that exclusively allows unique values and does not...
_____________________________________
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.April 14, 2012 at 6:08 pm
Viewing 15 posts - 331 through 345 (of 3,060 total)