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,354 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,221 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,620 reads

SSAS Cubes

By jconesa 2009/04/07 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,262 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 | 660 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,517 reads

Physical join

By Arup Chakraborty 2009/02/24 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 4,082 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 | 188 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 | 511 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 | 477 reads

IGNORE_DUP_KEY

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

Log File Page Size

By Tariq 2008/09/17 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,066 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,354 reads

Single Page Restore

By Steve Jones 2008/08/27 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,100 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,874 reads

Physical Database Architecture

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

Largest Unit

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

Which Type of Language

By 2008/02/15 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,460 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,088 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)