Viewing 15 posts - 496 through 510 (of 3,060 total)
Just loading a table hardly qualifies as ETL.
The term ETL, which stands for "Extract, Transform and Load" is usually used in the context of dimensional Data Warehousing referring to 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.February 11, 2012 at 1:04 pm
Rowles (2/10/2012)
In general what percentage of individual MS SQL databases are OLTP vs. OLAP vs. none of the above?
By definition a corporation should have a single DSS - Data Warehouse...
_____________________________________
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.February 11, 2012 at 12:42 pm
Dev (2/11/2012)
Does Oracle have an equivalent to SSIS?
yup... Oracle Warehouse Builder. IIRC it requires separate licenses.
To a certain extent but not the same...
...if you want to move 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.February 11, 2012 at 12:27 pm
Rowles (2/10/2012)
What are the steps necessary to partition tables and databases?
1- In regards to tables... plenty of documentation on the net - for a general view (don't be lazy) check...
_____________________________________
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.February 11, 2012 at 7:15 am
Rowles (2/10/2012)
Does Oracle...
_____________________________________
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.February 11, 2012 at 7:10 am
No. No workaround.
I would drop the offending FKs, set them back after the partition switch.
_____________________________________
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.February 9, 2012 at 2:01 pm
goodluck (2/6/2012)
Thanks- Yes, the indexes on the partitioned table are aligned and they serve the partitioning strategy.
Question is... are these aligned indexes serving "Quering Strategy"?
Check most used predicates...
_____________________________________
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.February 6, 2012 at 2:05 pm
Eliyahu (2/6/2012)
I have a busy service application that sometimes deletes 1-5 records from the 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.February 6, 2012 at 2:03 pm
Business Objects is still alive and kicking, also Cognos, MicroStrategy... Crystal Reports.
It mostly depends on: Budget, Available skill set and Personal preference.
_____________________________________
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.February 6, 2012 at 1:56 pm
goodluck (2/6/2012)
How do we align indexes and how different is it from rebuilding indexes?
An index is aligned when it was built using the same partition scheme and partitioning column/s as...
_____________________________________
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.February 6, 2012 at 1:50 pm
I'm sure you got Books On Line a.k.a. BOL alongside your SQL Server installation; start by reading about architecture then move to the example databases.
Once you start to get familiar...
_____________________________________
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.February 6, 2012 at 1:36 pm
One last question... any particular reason not to upgrade reporting SQL Server instance to SS2K8 R2? that would make things much easier and standardize your environment.
Check if you got...
_____________________________________
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.February 6, 2012 at 8:09 am
Dev (2/6/2012)
Physical distance plays a vital role in data transfer. Little Birdie might take 5 days to reach a destination 5K miles from the source database server.
If 5K...
_____________________________________
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.February 6, 2012 at 7:34 am
Dev (2/6/2012)...how far is Source and Target database Servers? Do you have any bandwidth constraints?
Database is 5 Gig in size! who cares about bandwith? you 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.February 6, 2012 at 7:22 am
Because BCP is a bulk operation.
_____________________________________
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.February 6, 2012 at 7:02 am
Viewing 15 posts - 496 through 510 (of 3,060 total)