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

Articles with tag Design and Theory Rss

Search for any content tagged design and theory

   Items 1 to 20 of 75    Older >>
 

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

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,348 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,853 reads

Changing Table Schema – what goes behind the scenes – Part II

Part two of his series on table schema changes, this article examines those changes that affect the actual data. Read this great article from Alok Dwivedi.  Read more...
By Alok Dwivedi 2009/08/05 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 4,627 reads

Changing Table Schema – what goes behind the scenes – Part I

What happens behind the scenes when you alter a table schema? New author Alok Dwivedi dives deep into SQL Server to show us how things are affected.  Read more...
By Alok Dwivedi 2009/08/03 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 7,552 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,348 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,214 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,610 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,507 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 | 500 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 | 466 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,348 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,853 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,087 reads

Using Data Warehouse for CRM

Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system.   Read more...
By Vincent Rainardi 2007/02/07 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 8,423 reads

The Dynamic Process of Loading Data

When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.   Read more...
By Janet Wong 2007/01/23 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,888 reads

Building a Quality BI Framework Solution Starts with a Quality ETL Sol

Developing an effective solution requires quality within and across all components of the BI architecture.   Read more...
By Additional Articles 2007/09/20 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 2,452 reads

Best-Practice Analytic Architecture to Support Business Strategy

A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.  Read more...
By Additional Articles 2007/09/06 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 2,014 reads
   Items 1 to 20 of 75    Older >>