Viewing 15 posts - 91 through 105 (of 3,060 total)
walshbd (5/8/2013)
_____________________________________
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.May 8, 2013 at 9:09 am
Tyberious Funk (5/8/2013)
_____________________________________
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.May 8, 2013 at 8:27 am
Carl0s_ (5/7/2013)
I have two tables (groups, rol), I need to know what's the correct way to create a relationship
my...
_____________________________________
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.May 8, 2013 at 8:20 am
jshurak (5/6/2013)
Executed as user: Domain\User. Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" 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.May 8, 2013 at 8:15 am
mah_j (5/4/2013)
I want to archive the data of a 400G table,what is the best way of archiving?
What's the reason behind "archiving" if as I understand it, all data would be...
_____________________________________
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.May 4, 2013 at 5:38 pm
Please research SLD of the type 2 (Slowly Changing 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.May 2, 2013 at 8:46 am
if emailing the report is part of Step #1 then the report gets email during Step #1 execution.
_____________________________________
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.May 1, 2013 at 12:41 pm
Schemas are not folders and you do not want to add any overhead to your database.
_____________________________________
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.May 1, 2013 at 11:08 am
Sqlism (4/30/2013)
Thanks Paul for your time.If i have data for Eg from
2009
2010
2011
2012
2013
How should i plan the partitioning for unexpected data where the date is like 1988 or 2050
Create 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.April 30, 2013 at 2:59 pm
Jon.Morisi (4/30/2013)
Unfortunately I don't know how to check if my statistics are being used. Any ideas?
Statistics ARE used.
To test the concept, do this.
1- Copy two related tables an write...
_____________________________________
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.April 30, 2013 at 2:39 pm
Sqlism (4/30/2013)
I am worried because it might cause performance issues.
Table partitioning is not about performance but administration.
In most cases a partitioning strategy is based on thinking how to make your...
_____________________________________
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.April 30, 2013 at 2:35 pm
rka (4/14/2013)
- Atomic
- 3rd NF
- Relational
But I disagree. I always considered DW models to be:
- Dimensional
-...
_____________________________________
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.April 30, 2013 at 2:21 pm
Sqlism (4/30/2013)
Status: In process
In Oracle : 6 Schemas
In SQL Server: Created a database with 6 Schemas.
-Every Schema has 3 Paritioned 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.April 30, 2013 at 2:11 pm
Fact is, you already have those books so I would go ahead and use them.
Plenty of information in the net about new/deprecated features between SQL Server versions therefore, 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.April 27, 2013 at 10:31 am
For documentation purposes I would create a table with the same schema, populate it with the "wrong" rows then, just run an update statement on the core table updating columns...
_____________________________________
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.April 9, 2013 at 8:50 am
Viewing 15 posts - 91 through 105 (of 3,060 total)