Viewing 15 posts - 1,366 through 1,380 (of 3,060 total)
vrkumar01 (10/25/2010)
i am very new to this forum.... we have SCOM R2 which monitors all our SQL servers which is quite ok and satisfied with the default SQL MP's.
today...
_____________________________________
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.October 27, 2010 at 1:32 pm
SQL ORACLE (10/26/2010)
We can create these two indexes sequentially.
We can also create these two indexes at the same time.
Which approach is faster?
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.October 26, 2010 at 2:49 pm
virpan_17 (10/26/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.October 26, 2010 at 2:27 pm
Unfortunatelly there is not such a thing as a SQL Server - Oracle Magic Decoder Ring.
I would suggest to check alter system, alter database, alter session syntax and options.
_____________________________________
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.October 26, 2010 at 2:18 pm
John Rowan (10/22/2010)
PaulB-TheOneAndOnly (10/22/2010)
John Rowan (10/22/2010)The execution plan shows a clustered index scan and returned results in under a second. This tells us that you don't even need 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.October 25, 2010 at 12:01 pm
ioani (10/22/2010)
CREATE TABLE Item
(
ItemID INT,
Name VARCHAR(60) ,
CategoryID TINYINT,
Subcategory
)
CategoryID from Item is a foreign key...
_____________________________________
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.October 22, 2010 at 12:47 pm
John Rowan (10/22/2010)The execution plan shows a clustered index scan and returned results in under a second. This tells us that you don't even need the non-clustered index on...
_____________________________________
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.October 22, 2010 at 12:38 pm
ioani (10/22/2010)
I have an entity named Item that has following attributes:
Item:
Name,
Category,
Subcategory
The database should enforce the following rules:
1.An item can belong to one of 3 categories;
2.A category 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.October 22, 2010 at 7:38 am
You certainly have a strong case for partitioning.
As you already pointed out partitioning is a great tool for archiving/purging purposes - the fact that you can switch a whole partition...
_____________________________________
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.October 22, 2010 at 7:31 am
Lynn Pettis (10/21/2010)
Using Oracle's SQL Developer stored procedures and functions are by default...
_____________________________________
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.October 22, 2010 at 6:52 am
SqlN00bie (10/20/2010)
We have a HUGE transaction table that is a good candidate for partitioning.RowCount : 62,187,467
Firstly... and not trying to hurt your feelings, as already pointed out by...
_____________________________________
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.October 21, 2010 at 12:32 pm
Welcome to the wonderfull world of troubleshooting 😀
Some of your "select into" queries is returning more than one row - either because of faulty data or faulty logic.
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.October 21, 2010 at 12:24 pm
Lynn Pettis (10/21/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.October 21, 2010 at 8:50 am
Where is the Package Header?
Where are the errors?
What's the question?
_____________________________________
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.October 20, 2010 at 8:26 pm
LutzM (10/20/2010)
PaulB-TheOneAndOnly (10/19/2010)
LutzM (10/16/2010)
Before going any further I'd like to know the true reason why you don't use the simple DELETE statement.
Well... imagine we are in the year 2030...
_____________________________________
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.October 20, 2010 at 2:11 pm
Viewing 15 posts - 1,366 through 1,380 (of 3,060 total)