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

   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 | 657 reads

Halloween Protection

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

Elementary Key Attributes

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

ACID Properties

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

NUMA

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

Page Compression

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

Lazy Writer

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

Ghost Records

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

Page compression

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

Know Your SQL Objects

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

Heaps

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

Normalization

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

Consistent Data Presentation

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

Design

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

Checksums

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

EAV Model

By Noel McKinney 2009/10/13 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 2,986 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,618 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,545 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 logs (1)