Viewing 15 posts - 241 through 255 (of 3,060 total)
Do not use export/import wizard, script your data load - first do your parent tables then your child tables as defined by Referential Integrity constraints.
An alternative would be to disable...
_____________________________________
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.July 23, 2012 at 7:46 am
leesider (7/23/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.July 23, 2012 at 5:37 am
Not need to even worry about the total number of rows stored across all your tables, performance is a function of the tables included in a particular query, the quality...
_____________________________________
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.July 22, 2012 at 4:49 pm
wanox (7/19/2012)
What can i use to track changes made st server level
Do you mean, 'server' as in the physical server? as in platform including O/S? as in platform including O/S...
_____________________________________
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.July 22, 2012 at 4:37 pm
ali.mahmoud.habib (7/22/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.July 22, 2012 at 4:34 pm
Jeff Moden (7/21/2012)
PaulB-TheOneAndOnly (7/21/2012)
Welsh Corgi (7/21/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.July 22, 2012 at 7:47 am
Welsh Corgi (7/21/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.July 21, 2012 at 4:56 pm
Welsh Corgi (7/21/2012)
I totally agree and understand that you do not want to delete records but flag them as inactive.
In general the inactive flag is not enough because it doesn't...
_____________________________________
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.July 21, 2012 at 3:29 pm
lokeshvij (7/20/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.July 21, 2012 at 2:46 pm
Build you own lab a.k.a. install SQL Server on your home computer then go to Books Online a.k.a. BOL (installed alongside SQL Server) and read the chapter about architecture.
After 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.July 21, 2012 at 2:39 pm
krishnasoft43 (7/21/2012)
WHAT IS THE TCP/IP ADDRESS IN SQL SERVER 2008 AND HOW TO CHANGE THAT ONE.
hey hey... no need to be that loud! 😀
I assume you are asking for 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.July 21, 2012 at 2:36 pm
richykong (7/20/2012)
...I used the MERGE statement and DELETE statements to handle all my ETL...
I do agree on the MERGE statement but I do not on the use of DELETE -...
_____________________________________
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.July 21, 2012 at 1:49 pm
Welsh Corgi (7/2/2012)
I'm creating Staging Tables in SQL Server and I was wondering what does a VARCHAR2(100 BYTE) or VARCHAR2(15 BYTE), etc translate to in SQL Server?
Ora11g allows 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.July 19, 2012 at 10:41 am
I'm sorry I'm not in agreement with the approach.
Provided each tenant actually owns its own data warehouse I wouldn't put all of them together in a single database - I...
_____________________________________
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.July 19, 2012 at 10:32 am
GRUNNINGER (7/3/2012)
... we have multiple products from multiple suppliers (Many to Many relationship)...
Break the many-to-many relationship - add a bridge table.
_____________________________________
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.July 16, 2012 at 6:06 am
Viewing 15 posts - 241 through 255 (of 3,060 total)