Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Data Warehousing Rss

   Items 1 to 20 of 316    Older >>
 

Exit Stage Right

By Dave 2014/07/24 | Category: data warehousing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,103 reads

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 3,248 reads

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,433 reads

Kimball ETL (subsystem 1) – Data Profiling via TSQL

This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)  Read more...
By Ira Whiteside 2014/02/12 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 3,544 reads

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL.  Read more...
By Todd Owens 2014/01/28 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 2,023 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,533 reads

Comparing Data Warehouse Design Methodologies for Microsoft SQL Server

In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.  Read more...
By Additional Articles 2013/07/03 | Source: MSSQLTips.com | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 4,451 reads

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL.  Read more...
By Todd Owens 2014/01/28 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 2,023 reads

A Data Hub

The idea of a data hub in your company is interesting to Steve Jones. He talks about this concept, and how it might help you increase data quality, and perhaps get closed to a single view of the truth.  Read more...
By Steve Jones 2012/08/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 193 reads

Track source dates when loading a data warehouse

A primer on how to reduce network and source system load when reading a relational source into the data warehouse.  Read more...
By Magarity Kerns 2012/07/30 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 3,635 reads

Kimball ETL (subsystem 1) – Data Profiling via TSQL

This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)  Read more...
By Ira Whiteside 2014/02/12 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 3,544 reads

Data Warehouse Architecture – Kimball and Inmon methodologies

What is the best methodology to use when creating a data warehouse?  Well, first off, let’s discuss some of the reasons why...  Read more...
By 2012/03/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,951 reads

Date Dimension

Here is a simple script that I use to create a Date Dimension table.  Read more...
By Satish Jayanthi 2012/01/11 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,695 reads

PASS Data Architecture VC presents Row Versioned Data Warehouses with Jeremy Huppatz

On Thursday December 15th at 8PM Pacific, Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse   Read more...
By Press Release 2011/12/15 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,614 reads

Slowly changing dimensions using T-SQL MERGE

Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.   Read more...
By Adam Aspin 2011/06/20 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 15,121 reads

Scaling Up Your Data Warehouse with SQL Server 2008 R2

SQL Server 2008 introduced many new functional and performance improvements for data warehousing, and SQL Server 2008 R2 includes all these and more. This paper discusses how to use SQL Server 2008 R2 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers. Our testing indicates that many customers can expect their performance to nearly double on the same hardware they are currently using, merely by upgrading to SQL Server 2008 R2 from SQL Server 2005 or earlier, and compressing their fact tables. We cover techniques to improve manageability and performance at high-scale, encompassing data loading (extract, transform, load), query processing, partitioning, index maintenance, indexed view (aggregate) management, and backup and restore.  Read more...
By Additional Articles 2011/05/19 | Source: Microsoft MSDN | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,489 reads

Functions for using the keys from the Date and Time Dimensions

Three functions for obtaining the date and time dimension keys with a date or the date from the keys  Read more...
By Joshua A. Walker 2011/05/03 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,203 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,533 reads

Understanding and Controlling Parallel Query Processing in SQL Server

Data warehousing and general reporting applications tend to be CPU intensive because they need to read and process a large number of rows. To facilitate quick data processing for queries that touch a large amount of data, Microsoft SQL Server exploits the power of multiple logical processors to provide parallel query processing operations such as parallel scans. Through extensive testing, we have learned that, for most large queries that are executed in a parallel fashion, SQL Server can deliver linear or nearly linear response time speedup as the number of logical processors increases. However, some queries in high parallelism scenarios perform suboptimally. There are also some parallelism issues that can occur in a multi-user parallel query workload. This white paper describes parallel performance problems you might encounter when you run such queries and workloads, and it explains why these issues occur. In addition, it presents how data warehouse developers can detect these issues, and how they can work around them or mitigate them.  Read more...
By Additional Articles 2010/12/10 | Source: MSDN Communities | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,428 reads

3 Fundamental Questions about Data Marts...and Their Answers

A data mart provides the primary access to the data stored in the data warehouse or operational data store. It is a subset of data sourced from the data warehouse or operational data store specifically focused on a business function or set of related business functions. Read on to learn the answers to fundamental questions about data marts.  Read more...
By Additional Articles 2010/12/03 | Source: Database Journal | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,954 reads
   Items 1 to 20 of 316    Older >>
 
Tags
miscellaneous (69)    
analysis services (ssas) (62)    
design and theory (58)    
maintenance and management (29)    
t-sql (29)    
sqlinsider scripts (12)    
olap server (11)    
data mining (10)    
sql server 2008 (10)    
etl (7)    
sql server 7 (7)    
backup / restore (6)    
replication (6)    
indexing (5)    
integration services (ssis) (5)    
programming (5)    
administration (4)    
business intelligence (4)    
extract, transform, load (etl) (4)    
mdx (4)    
news (4)    
database design (3)    
lock and connection management (3)    
mail (3)    
reporting services (ssrs) (3)    
scalability (3)    
sql server 2005 (3)    
best practices (2)    
blogs (2)    
code generation (2)    
data profiling (2)    
datawarehouse (2)    
datetime (2)    
development (2)    
dimensions (2)    
dts (2)    
editorial (2)    
interviews (2)    
mdm (2)    
merge (2)    
online (2)    
partition (2)    
partitioning (2)    
performance tuning (2)    
slowly changing dimensions (2)    
sql server (2)    
webinar (2)    
ado (1)    
advanced (1)    
advanced querying (1)    
basics (1)    
book reviews (1)    
capacity planning (1)    
change data capture (cdc) (1)    
cloud services (1)    
columnstore index (1)    
data (1)    
data compression (1)    
data mart (1)    
database weekly (1)    
dba (1)    
defragmentation (1)    
dimensional modeling (1)    
employee dimension (1)    
events (1)    
fast track data warehouse (1)    
hashbytes (1)    
master data services (mds) (1)    
mpp (1)    
multi-tenant (1)    
parallel (1)    
populate (1)    
product reviews (1)    
rebuild (1)    
reviews (1)    
sql server 2008 r2 (1)    
star join (1)    
star schemas (1)    
strategies (1)    
try..catch (1)    
very large table (1)    
visual basic 6 (1)    
warehouse (1)