Viewing 15 posts - 3,001 through 3,015 (of 3,060 total)
if the guy doesn't want to give your the download credentials just ask the guy to download it for you and put it in a share someplace in the network.
_____________________________________
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.August 22, 2008 at 3:36 am
You are facing a capacity planning issue.
Just in case, what's your timeout setup for the offending environment?
_____________________________________
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.August 22, 2008 at 3:31 am
1- Script offending database creation
2- Take a full backup
3- Drop your offending database
4- Delete mdf, ndf and ldf related datafiles.
5- Alter database creation script setting -perhaps - 2 Gig for...
_____________________________________
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.August 22, 2008 at 3:28 am
You said FACT table therefore you are talking about a Data Warehouse environment.
You do not use a natural PK on Data Warehouse, by using surrogate keys you are doing 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.August 19, 2008 at 10:47 am
please post the result of...
SELECT count(*)
FROM Database.dbo.trace
WHERE textdata like '%UpdateAccount%'
_____________________________________
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.August 19, 2008 at 10:35 am
As a quick workaround you can always add a WAITFOR DELAY command in your loop, that would free resources for other sessions to use in each iteration of your WHILE...
_____________________________________
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.August 18, 2008 at 4:32 am
Is it possible to partition tables in a database??If so will it help in improving the performance???
Yes.
Yes, providing you implement the right partitioning strategy.
Partitioning strategy should target at least 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.August 18, 2008 at 2:00 am
You are not telling how you are doing it right now so it's kind of hard to suggest something better.
Lets go to the basics.
LOGINS...
... belong to the instance therefore if...
_____________________________________
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.August 15, 2008 at 10:08 am
shiwani2002sg (8/11/2008)
hito take bakup of oracle databae, use file starting with 'imp' . It must be residing in 'bin' folder inside the folder containing oracle.
I see... you didn't even...
_____________________________________
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.August 12, 2008 at 1:55 am
California (8/11/2008)
I have 4 indexes (1 clustered and 2 non-clustered) on a table which is 105 GB.
100% support Jeffrey.
By the way, I'm wondering of what kind your fourth index 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.August 12, 2008 at 1:47 am
This is a text book example of what you may expect to happen when people tries to pack the application's logic into triggers.
Application's logic should be on the application side.
_____________________________________
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.August 9, 2008 at 12:05 pm
... and the question 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.August 9, 2008 at 11:49 am
:w00t: May be is because of the bottle of Brandy but believe me I couldn't figure it out what are you looking for... I'll check back when I back 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.August 9, 2008 at 11:46 am
Heather (8/8/2008)
I'm trying to figure out why someone would use a linked server over just having another database on the same server.
Here is a reason...
Picture this scenario, you work 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.August 9, 2008 at 5:40 am
Some day somebody is going to tell me the truth about why SQL Server partitioning is such a nightmare.
Don't understand why. Other RDBMS developed the technology before and made it...
_____________________________________
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.August 8, 2008 at 9:55 am
Viewing 15 posts - 3,001 through 3,015 (of 3,060 total)