Viewing 15 posts - 2,686 through 2,700 (of 3,060 total)
Described archive and purge strategy is not sustainable on a large production environment.
I would suggest to re-architect involved tables so you can rely on partition switching; this is going 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.February 25, 2009 at 5:45 am
Sakthivel Chidambaram (2/24/2009)
So SQL 200 to 2005 migration is possible? 😀
That's a very old version ! Reminds me of when I was programming on the AS/400 and...
_____________________________________
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.February 25, 2009 at 3:15 am
free_mascot (2/25/2009)
"Thare are only 10 types of people in the world:Those who understand binary, and those who don't."
😀 You made my day!
_____________________________________
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.February 25, 2009 at 3:09 am
peace2007 (2/25/2009)
What may cause such low performance?
Is this the only poor-performing query or you are seeing poor performance all across the board?
Check execution plan, be sure query takes advantage...
_____________________________________
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.February 25, 2009 at 3:06 am
Muhammad Haseeb Farhan (2/24/2009)
Can you please tell me the way how can i decompose this 3 gig memory
:w00t: Memory decomposition is a fairly new concept on the digital world 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.February 24, 2009 at 8:12 am
...mmhhh ... by making the right selection perhaps?
_____________________________________
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.February 24, 2009 at 8:04 am
HanShi (2/24/2009)
Sakthivel Chidambaram (2/24/2009)
So SQL 200 to 2005 migration is possible? 😀
Migration from SQL 2000 to a new version (2005 or 2008) is possible, but if you want to migrate...
_____________________________________
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.February 24, 2009 at 8:03 am
Lee From Bangalore (2/23/2009)
I need Procedure to migrate MYSQL database to MSSQL Server 2005.
This is a very well documented matter, you may want to start by checking this TechNet document...
_____________________________________
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.February 24, 2009 at 2:05 am
klnsuddu (2/23/2009)
_____________________________________
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.February 24, 2009 at 2:00 am
You may want to check this step-by-step guide to migrate from SS2000 to SS2005 http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html#
_____________________________________
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.February 24, 2009 at 1:54 am
Clearly define your rules, if they are systemic you can write a query which output would be the code you have to execute.
One of the beauties of RDBMS is 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.February 20, 2009 at 3:19 am
Md Yaqoob (2/19/2009)
I have a Sql Server 2000 and .net platform...
The result in my front application is the result from the view directly.
The view gives me 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.February 20, 2009 at 3:08 am
dale_keller (2/19/2009)
... but if someone accidentally drops the database your code is gone.
:w00t: if this is the case your problems run deeper than code version control my friend.
I would...
_____________________________________
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.February 20, 2009 at 3:04 am
4DJ**** (2/17/2009)
_____________________________________
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.February 18, 2009 at 2:28 am
archan.arch (2/18/2009)
i am just doing a study about data migration .i am interested to know about
migrating from oracle to sql.
what are pitfalls to look out for?
as in what...
_____________________________________
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.February 18, 2009 at 2:23 am
Viewing 15 posts - 2,686 through 2,700 (of 3,060 total)