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 313    Older >>
 

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,415 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 | 1,979 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,095 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,328 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 | 1,979 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 | 192 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,626 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,415 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,164 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,629 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,532 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 | 14,841 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,409 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,123 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,095 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,353 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,889 reads

A Quick Look at the MPP World

David Poole takes a look at the Massively Parallel Processing world for database servers.  Read more...
By David Poole 2010/08/11 | Source: SQLServerCentral.com | Category: mpp
Rating: |  Discuss |   Briefcase | 4,413 reads

Data Distribution - Part 1

The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.  Read more...
By Leo Peysakhovich 2010/07/26 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 6,756 reads

Building a Data Warehouse Blueprint for Success

One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential.  Read more...
By Additional Articles 2010/07/09 | Source: Database Journal | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 1,099 reads
   Items 1 to 20 of 313    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)    
sql server 7 (7)    
backup / restore (6)    
etl (6)    
replication (6)    
indexing (5)    
programming (5)    
administration (4)    
business intelligence (4)    
extract, transform, load (etl) (4)    
integration services (ssis) (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)    
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)    
mpp (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)