Viewing 15 posts - 1,276 through 1,290 (of 3,060 total)
johnacandy (12/14/2010)
Suppose that i have the following staging table with the following columns...
As a side note I'll say you should never start with the Staging table but with the actual...
_____________________________________
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.December 18, 2010 at 9:03 am
pdanes2 (12/9/2010)
De-normalize or index?
Question could be translated like "be healthy or take a fast speed train?" meaning, those options should never be part of the same question.
Normalization/De-Normalization is related 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.December 18, 2010 at 8:50 am
jln (12/15/2010)
So I basically need to go talk to SQL server support at...
_____________________________________
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.December 15, 2010 at 9:14 am
jln (12/15/2010)
Where can i find information on the bug you mention, are there any...
_____________________________________
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.December 15, 2010 at 8:56 am
Lowell (12/15/2010)
...Once you have the Linked Server in place I have found a few different ways of interacting with the mysql database
I understand poster is looking for the other way...
_____________________________________
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.December 15, 2010 at 7:56 am
Described behavior appears to be closely related to bug #50002862
Do you really need snapshot isolation or was it just a test?
_____________________________________
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.December 15, 2010 at 7:49 am
naresh.talla (12/14/2010)
my question is how i can read data...
_____________________________________
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.December 15, 2010 at 7:42 am
DBA in Unit 7 (12/15/2010)
_____________________________________
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.December 15, 2010 at 7:04 am
456789psw (12/13/2010)
_____________________________________
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.December 14, 2010 at 5:49 am
Steve Jones - SSC Editor (12/10/2010)Developers SHOULD NOT be able to change objects (tables, stored procedures, etc.) on production.
Agreed and, SHOULD NOT be able to change/create/drop objects in Test either...
_____________________________________
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.December 14, 2010 at 5:45 am
MonsterRocks (12/14/2010)
in sql 2k5, i have a database.. i want to take its schema diagram.. is there any tool available for it?.. any suggestion pls
SQL Server Management Studio/
Databases/
target_database/
Database Diagrams/
New
🙂
_____________________________________
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.December 14, 2010 at 5:38 am
netpicker9 (12/8/2010)
1. Company
2. Client
3. Branch
4. Departments
Points:
a. Some companies do not have any branches and just departments
b. If company happen have...
_____________________________________
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.December 10, 2010 at 8:43 am
rajesh999 (12/6/2010)
•Data should be retained for 5 years or 60 months.
•Table will have about 800 million records
•Have adapted monthly partition.
•Each File group have 8 files to match the Number 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.December 10, 2010 at 8:36 am
Building on torpkev's comment, this is too specific for a third party application - this is something you have to do by yourself.
By the way, no need to bother developers...
_____________________________________
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.December 10, 2010 at 8:29 am
I'll start by checking "Forum" user default schema.
_____________________________________
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.December 10, 2010 at 8:22 am
Viewing 15 posts - 1,276 through 1,290 (of 3,060 total)