Viewing 15 posts - 406 through 420 (of 3,060 total)
krishnavamshi24 (3/25/2012)
_____________________________________
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.March 26, 2012 at 7:40 am
codebyo (3/25/2012)
_____________________________________
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.March 26, 2012 at 7:35 am
Farnaz Safaee Nik (3/25/2012)
_____________________________________
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.March 25, 2012 at 3:25 pm
Welsh Corgi (3/24/2012)
I just need a clear and concise quick argument as to what they have done is wrong.
Surrogate Keys add a level of abstraction that isolates and protects the...
_____________________________________
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.March 25, 2012 at 1:01 pm
Welsh Corgi (3/24/2012)
_____________________________________
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.March 25, 2012 at 12:49 pm
murarka.ankita2007 (3/25/2012)
please convert below code of sql server to sql plusso that it doesnt generate syntax error.
Please don't take this the wrong way but this is so wrong it 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.March 25, 2012 at 12:38 pm
krishnavamshi24 (3/25/2012)
_____________________________________
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.March 25, 2012 at 12:27 pm
Welsh Corgi (3/23/2012)I'm concerned about the time it takes to back up the Database and recover it.
By definition Staging tables should be truncated and loaded on each ETL cycle...
_____________________________________
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.March 24, 2012 at 7:12 pm
Welsh Corgi (3/23/2012)The design does not even come close to a Star Schema or Star Snowflake Schema.
Nothing that indicates a Fact Table or Dimensional table, just a repeat of the...
_____________________________________
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.March 24, 2012 at 7:08 pm
Welsh Corgi (3/23/2012)
PaulB-TheOneAndOnly (3/23/2012)
Welsh Corgi (3/23/2012)
Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.
This is common practice in...
_____________________________________
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.March 23, 2012 at 3:19 pm
Lynn Pettis (3/23/2012)
GilaMonster (3/23/2012)
sandeep4testing (3/23/2012)
FK- FName should be FK of Users.FNameFK- LName should be FK of Users.LName
Names as foreign keys? That's a weird design.
Even weirder is that from the looks...
_____________________________________
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.March 23, 2012 at 1:40 pm
Welsh Corgi (3/23/2012)
Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.
This is common practice in "some" RDBMS other...
_____________________________________
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.March 23, 2012 at 1:24 pm
Confusing Queries (3/23/2012)
Now we have created new indexes specially...
_____________________________________
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.March 23, 2012 at 1:18 pm
Lynn Pettis (3/23/2012)Here is the other problem, your table can have only ONE primary key.
Yup... just a basic, tiny, tiny, small like this (shows finger tips real close) detail, init?...
_____________________________________
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.March 23, 2012 at 1:15 pm
gyoung,
There is something we call best practices which basically means we do stuff in certain ways that have proven over time to be the most efficient ones in terms of...
_____________________________________
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.March 23, 2012 at 1:06 pm
Viewing 15 posts - 406 through 420 (of 3,060 total)