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,299 reads

Elementary Key Attributes

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

Rating: (not yet rated) |

Briefcase | 2,307 reads

ACID Properties

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

Rating: (not yet rated) |

Briefcase | 2,225 reads

NUMA

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

Rating: (not yet rated) |

Briefcase | 2,416 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,563 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,180 reads

Heaps

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

Rating: (not yet rated) |

Briefcase | 2,601 reads

Normalization

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

Rating: (not yet rated) |

Briefcase | 3,024 reads

Consistent Data Presentation

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

Rating: (not yet rated) |

Briefcase | 2,389 reads

Design

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

Rating: (not yet rated) |

Briefcase | 3,754 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,193 reads

Checksums

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

Rating: (not yet rated) |

Briefcase | 3,510 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,449 reads

EAV Model

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

Rating: (not yet rated) |

Briefcase | 2,972 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,574 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,512 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,193 reads

Items 1 to 20 of 143 Next 20 >>