Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Design and Theory Rss

   Items 1 to 20 of 144    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 | 668 reads

Halloween Protection

By Steve Jones 2012/10/31 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,493 reads

Elementary Key Attributes

By Tom Thomson 2011/10/05 | Category: normalisation
Rating: (not yet rated) |  Discuss |   Briefcase | 2,415 reads

ACID Properties

By Srawan 2011/09/07 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,301 reads

NUMA

By Steve Jones 2011/06/14 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,481 reads

Page Compression

By Steve Jones 2011/06/13 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,355 reads

Lazy Writer

By Steve Jones 2011/06/10 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,523 reads

Ghost Records

By Steve Jones 2011/06/02 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,623 reads

Page compression

By Steve Jones 2011/05/27 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,289 reads

Know Your SQL Objects

By Brandie Tarvin 2011/05/13 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,258 reads

Heaps

By Steve Jones 2011/05/04 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,663 reads

Normalization

By Steve Jones 2011/04/27 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,082 reads

Consistent Data Presentation

By Dave 2011/04/20 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,428 reads

Design

By Stewart Campbell 2010/09/24 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,824 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,422 reads

Checksums

By Paul Randal 2010/02/17 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,548 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 | 38,067 reads

EAV Model

By Noel McKinney 2009/10/13 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,005 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,647 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,576 reads
   Items 1 to 20 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 log (1)