SQLServerCentral: Content tagged T-SQL, SQL Server

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question. Read more...

By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 6,341 reads

An in-depth look at change detection in SQL Server - Part 02

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server. Read more...

By Nakul Vachhrajani 2013/02/19 | Source: SQLServerCentral.com | Category: sql server

Rating:

|

Discuss |

Briefcase | 5,221 reads

An in-depth look at change detection in SQL Server - Part 01

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server. Read more...

By Nakul Vachhrajani 2013/02/12 | Source: SQLServerCentral.com | Category: change detection

Rating:

|

Discuss |

Briefcase | 2,432 reads

Identity Values – Two things to know

I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s... Read more...

By Steve Jones 2010/01/08 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 3,767 reads

Indexing HierarchyID

The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that... Read more...

By Steve Jones 2009/09/03 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,172 reads

Replication – Accommodating Application Inserts

Recently I have been involved in lots of projects involving replication. I have done some things to make replication work... Read more...

By Patrick LeBlanc 2009/08/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,130 reads

Adding Multiple Columns to a Table With a Single T-SQL Statement

You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a... Read more...

By Patrick LeBlanc 2009/08/13 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 22,548 reads

Content with tags T-SQL, SQL Server

HASHBYTES: Is CHECKSUM really required?

An in-depth look at change detection in SQL Server - Part 02

An in-depth look at change detection in SQL Server - Part 01

Identity Values – Two things to know

Indexing HierarchyID

Replication – Accommodating Application Inserts

Adding Multiple Columns to a Table With a Single T-SQL Statement