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

Content with tag design and theory Rss

<< Newer    Items 21 to 40 of 144    Older >>
 

ANSI PADDING, Trailing Whitespace, and Variable Character Columns

What does ANSI_PADDING mean and how does it affect my SQL Server database?  Read more...
By Jack Corbett 2010/07/16 (first published: 2008/09/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,315 reads

Planning Your First Microsoft BI Solution

Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner  Read more...
By Additional Articles 2009/07/21 | Source: TechNet Blogs | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 3,184 reads

Attribute Discretization: Using the Automatic Method

Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,583 reads

SSAS Cubes

By jconesa 2009/04/07 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,242 reads

The T-SQL Paradigm

This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?  Read more...
By Steve Jones 2013/11/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 654 reads

The Flaws of the Classic Data Warehouse Architecture, Part 1

Visit ten randomly picked customers that own a data warehouse architecture, and you will see that at least eight have developed a classic data warehouse architecture (CDWA). What do I mean by a CDWA? In a CDWA, data is copied periodically from production systems to the central data warehouse.  Read more...
By Additional Articles 2009/03/20 | Source: B-Eye | Category: data warehousing
Rating:  Rate this |   Briefcase | 5,483 reads

Physical join

By Arup Chakraborty 2009/02/24 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 4,073 reads

The Fear of Change

Steve Jones reacts to the announcement of "fabrics" in the future of SQL Server.  Read more...
By Steve Jones 2008/12/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 187 reads

The Fear of Change

Steve Jones reacts to the announcement of "fabrics" in the future of SQL Server.  Read more...
By Steve Jones 2008/12/01 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 469 reads

The Fear of Change

Steve Jones reacts to the announcement of "fabrics" in the future of SQL Server.  Read more...
By Steve Jones 2008/12/01 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 430 reads

IGNORE_DUP_KEY

By Hugo Kornelis 2008/11/05 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,546 reads

Log File Page Size

By Tariq 2008/09/17 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,060 reads

ANSI PADDING, Trailing Whitespace, and Variable Character Columns

What does ANSI_PADDING mean and how does it affect my SQL Server database?  Read more...
By Jack Corbett 2010/07/16 (first published: 2008/09/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,315 reads

Single Page Restore

By Steve Jones 2008/08/27 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,096 reads

Introduction to the Transaction Log

The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.  Read more...
By James Rea 2009/11/06 (first published: 2008/07/02) | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 37,715 reads

Physical Database Architecture

By Todd Engen 2008/05/28 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,970 reads

Largest Unit

By Herb Overstreet 2008/04/04 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,948 reads

Which Type of Language

By 2008/02/15 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,454 reads

Problems In Building a Data Warehouse

Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this type of project.   Read more...
By Janet Wong 2007/03/05 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 7,074 reads
<< Newer    Items 21 to 40 of 144    Older >>
 
Tags
data warehousing (58)    
analysis services (ssas) (7)    
t-sql (4)    
olap server (3)    
business intelligence (2)    
career (2)    
editorial (2)    
sql server 2005 (2)    
table information (2)    
basics (1)    
database design (1)    
development (1)    
dts (1)    
editorial - ipod (1)    
editorial - wmv (1)    
integration services (ssis) (1)    
mdx (1)    
miscellaneous (1)    
normalisation (1)    
numa (1)    
product reviews (1)    
reporting services (ssrs) (1)    
reviews (1)    
sql server 7 (1)    
transaction logs (1)