Viewing 15 posts - 1,486 through 1,500 (of 3,060 total)
rwyatt292 (10/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.October 1, 2010 at 2:46 pm
spsql (9/30/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 1, 2010 at 1:10 pm
Derrick Smith (9/30/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.September 30, 2010 at 3:31 pm
Michael Valentine Jones (9/30/2010)
PaulB-TheOneAndOnly (9/30/2010)
Michael Valentine Jones (9/30/2010)
PaulB-TheOneAndOnly (9/30/2010)
Michael Valentine Jones (9/30/2010)
If you leave the table as a heap, you cannot reorganize the table to remove unused space.why not?
Since, 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.September 30, 2010 at 2:43 pm
samalex (9/30/2010)
PaulB-TheOneAndOnly (9/30/2010)
This looks like multi-master referential integrity - you can implement via triggers instead of implementing via FK constraints.
I'm unfamiliar with multi-master referential integrity and can't find much about...
_____________________________________
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.September 30, 2010 at 2:40 pm
I'm in agreement with Gail.
In a star-schema data warehouse you usually end up with one index per each dimension pointing to a fact table so, "n" dimensions pointing to a...
_____________________________________
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.September 30, 2010 at 2:29 pm
samalex (9/30/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.September 30, 2010 at 2:23 pm
Michael Valentine Jones (9/30/2010)
PaulB-TheOneAndOnly (9/30/2010)
Michael Valentine Jones (9/30/2010)
If you leave the table as a heap, you cannot reorganize the table to remove unused space.why not?
Since, it is a heap with...
_____________________________________
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.September 30, 2010 at 1:50 pm
Michael Valentine Jones (9/30/2010)
If you leave the table as a heap, you cannot reorganize the table to remove unused space.
why not?
_____________________________________
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.September 30, 2010 at 1:24 pm
Please try this.
Test by creating a covered index on ...
b.sending_app,
b.event_time,
b.message_type,
b.receiving_app,
b.service_name,
b.direction
... please order columns from the most restrictive to the less restrictive and let selected columns that are not referenced...
_____________________________________
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.September 30, 2010 at 11:37 am
:blink: I'm a little confused here.
First post identifies the table as being [dbo].[MessageLog] - ddl was provided.
Query is referencing table [Message_Journal].[dbo].[Journal]
Are both the same?
_____________________________________
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.September 30, 2010 at 11:17 am
itskumar2004 (9/29/2010)
Table ABC:
columnname datatype
ID ...
_____________________________________
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.September 30, 2010 at 8:04 am
jackimo (9/30/2010)
There are non-clustered indexes on uuid, service_name, event_time,last_name and personid.
Basically any report that causes a full table scan takes a long time (around an hour...
_____________________________________
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.September 30, 2010 at 6:34 am
vinothraj (9/23/2010)
We need to create a clustered index by implementing schema binding in the view.
Lets start over?
Post is kind of confusing.
1- Clustered indexes have their leaf level inside the target...
_____________________________________
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.September 30, 2010 at 6:27 am
Please post ...
1- Available indexes
2- Predicate a.k.a "where clause" of offending queries.
_____________________________________
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.September 30, 2010 at 6:11 am
Viewing 15 posts - 1,486 through 1,500 (of 3,060 total)