Viewing 15 posts - 2,806 through 2,820 (of 3,060 total)
Not totally sure why you are "suspicious" of that reindexing job; perhaps you have some information you haven't shared yet?
Could you please post space usage as follows?...
Data space
-- Data
-- Indexes
--...
_____________________________________
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.November 16, 2008 at 12:18 pm
I would do a standard Oracle client installation.
Trying to trim the client software looks to me like a attempt to get into troubles.
_____________________________________
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.November 12, 2008 at 4:14 am
vyas (11/4/2008)
So I would like to know no of tables and table structures,fk,pk and table relations to be created for this db design.
mmmhhh...
On one hand please note I volunteer...
_____________________________________
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.November 4, 2008 at 5:43 am
vyas (11/4/2008)
Yup there will not be any OLTP and DSS.
If this is the case I suppose you would be concerned about indexing and searching; are you sure a search appliance...
_____________________________________
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.November 4, 2008 at 4:25 am
vyas (11/4/2008)
_____________________________________
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.November 4, 2008 at 4:16 am
You are talking about three very different things, they are not remotely compatible.
Export -which is not technically a backup would generate a dump file; you are free to see what's...
_____________________________________
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.November 4, 2008 at 1:39 am
Lets go step by step here.
1- Export. Since you cannot recover a database from an export dump, export is not considered a backup. Either way export would write a log...
_____________________________________
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.November 3, 2008 at 3:42 am
You may want to have more than one instance in a box when:
1- You are planing to have different setups in each one
Benefits...
...independent setups may benefit when you have two...
_____________________________________
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 31, 2008 at 5:00 am
Why don't you test it?
Look...
USE pubs
go
CREATE TABLE dbo.master_table
(
mykey numeric(5) NOT NULL,
mydata varchar(10) NULL
)
go
CREATE TABLE dbo.variable_table
(
...
_____________________________________
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 31, 2008 at 4:03 am
Yes. There are probably more than a couple of ways of doing it, let me share with you the good-n-old pivot table way; not doing your job but here 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.October 31, 2008 at 3:47 am
Something is wrong in your scenario.
Dimensions are supposed to describe Factual attributes so you shouldn't be doing a query in Dimensions alone.
Usually you query Factual tables while using related Dimensions...
_____________________________________
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 30, 2008 at 11:51 am
In a Data Warehouse environment you define FKs just to let the system know there is a relationship but normally you disable them.
The idea is ... you want...
_____________________________________
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 30, 2008 at 11:45 am
...are you asking a DB2 question in the Oracle section of a SQL Server forum?
_____________________________________
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 30, 2008 at 8:49 am
Makarand Mohandas (10/30/2008)
If your tempdb wants to get to that size let it infact give it more space.
...or revise you application, there is a reason why TempDB grows that way...
_____________________________________
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 30, 2008 at 2:55 am
my choice would be a Full Table Scan in your larger table, then pack the predicate with as many inline views as you can, all of them doing Full Table...
_____________________________________
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 30, 2008 at 2:51 am
Viewing 15 posts - 2,806 through 2,820 (of 3,060 total)