Viewing 15 posts - 1,291 through 1,305 (of 3,060 total)
sani (12/7/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 10, 2010 at 8:11 am
vinothraj (12/6/2010)
1) Instead of having Default value on column, insert explicitly default value.
2) Keep column constraint as NULL(Eventhough it ll not have NULL at any time) & explicitly take care...
_____________________________________
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 8, 2010 at 2:55 pm
Thank you Gail.
I got the Null constraint, what you say makes sense.
In regards to Check constraint, still not sure how can a check contraint have an impact on execution plan...
_____________________________________
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 5, 2010 at 5:17 pm
Jeff Moden (12/4/2010)
PaulB-TheOneAndOnly (12/4/2010)
Jeff Moden (12/4/2010)
PaulB-TheOneAndOnly (12/4/2010)
I've seen...
_____________________________________
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 5, 2010 at 4:54 pm
Brigadur (12/4/2010)
PaulB-TheOneAndOnly (12/4/2010)
GilaMonster (12/4/2010)
PaulB-TheOneAndOnly (12/3/2010)
Brigadur (12/3/2010)
Constraints can actually be used by the optimizer to speed up a query.Hope you are referring to Referential Integrity constraints.
Check and not null constraints can...
_____________________________________
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 5, 2010 at 8:37 am
GilaMonster (12/4/2010)
PaulB-TheOneAndOnly (12/3/2010)
Brigadur (12/3/2010)
Constraints can actually be used by the optimizer to speed up a query.Hope you are referring to Referential Integrity constraints.
Check and not null constraints can too.
mmmhhh... 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.December 4, 2010 at 3:57 pm
Jeff Moden (12/4/2010)
PaulB-TheOneAndOnly (12/4/2010)
I've seen many tables where...
_____________________________________
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 4, 2010 at 3:51 pm
Jeff Moden (12/3/2010)
PaulB-TheOneAndOnly (12/3/2010)
Subjet of this thread is...
Sachin Vaidya (11/23/2010)
Huge tables with no appropriate column for creating clustered index!
...and I say "so what?" 😀
There 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.December 4, 2010 at 7:39 am
May I spice this one?
Subjet of this thread is...
Sachin Vaidya (11/23/2010)
Huge tables with no appropriate column for creating clustered index!
...and I say "so what?" 😀
There is the common missunderstanding...
_____________________________________
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 3, 2010 at 2:31 pm
Brigadur (12/3/2010)
Constraints can actually be used by the optimizer to speed up a query.
Hope you are referring to Referential Integrity constraints.
_____________________________________
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 3, 2010 at 2:24 pm
Brandie Tarvin (12/3/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 3, 2010 at 2:13 pm
RainbowFfolly (12/1/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 3, 2010 at 8:49 am
I think this is a job for "Captain Obvious"! 😀
How about creating a new table, populating the new table and dropping the old 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.December 3, 2010 at 8:39 am
:pinch: business specs with a simple numeric example wouldn't hurt.
_____________________________________
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 3, 2010 at 8:33 am
so... no answers at all to our questions? 😀
_____________________________________
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 2, 2010 at 11:20 am
Viewing 15 posts - 1,291 through 1,305 (of 3,060 total)