Viewing 15 posts - 496 through 510 (of 3,061 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...
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...
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...
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...
February 11, 2012 at 7:15 am
Rowles (2/10/2012)
Does Oracle...
February 11, 2012 at 7:10 am
No. No workaround.
I would drop the offending FKs, set them back after the partition switch.
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...
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...
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.
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...
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...
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...
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...
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...
February 6, 2012 at 7:22 am
Viewing 15 posts - 496 through 510 (of 3,061 total)