SQLServerCentral: Content tagged design and theory

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tag design and theory

Items 1 to 20 of 143 Next 20 >>

Halloween Protection

By Steve Jones 2012/10/31 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,303 reads

Elementary Key Attributes

By Tom Thomson 2011/10/05 | Category: normalisation

Rating: (not yet rated) |

Briefcase | 2,308 reads

ACID Properties

By Srawan 2011/09/07 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,227 reads

NUMA

By Steve Jones 2011/06/14 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,417 reads

Page Compression

By Steve Jones 2011/06/13 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,289 reads

Lazy Writer

By Steve Jones 2011/06/10 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,438 reads

Ghost Records

By Steve Jones 2011/06/02 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,565 reads

Page compression

By Steve Jones 2011/05/27 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,235 reads

Know Your SQL Objects

By Brandie Tarvin 2011/05/13 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 3,181 reads

Heaps

By Steve Jones 2011/05/04 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,602 reads

Normalization

By Steve Jones 2011/04/27 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 3,025 reads

Consistent Data Presentation

By Dave 2011/04/20 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,390 reads

Design

By Stewart Campbell 2010/09/24 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 3,757 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:

|

Briefcase | 23,197 reads

Checksums

By Paul Randal 2010/02/17 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 3,511 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:

|

Briefcase | 37,460 reads

EAV Model

By Noel McKinney 2009/10/13 | Category: design and theory

Rating: (not yet rated) |

Briefcase | 2,974 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:

|

Briefcase | 4,575 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:

|

Briefcase | 7,513 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:

|

Briefcase | 23,197 reads

Items 1 to 20 of 143 Next 20 >>