SQLServerCentral.com Content tagged SQL Server, T-SQL

HASHBYTES: Is CHECKSUM really required?

Wed, 27 Mar 2013 06:00:00 UT

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.

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

Tue, 19 Feb 2013 07:00:00 UT

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.

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

Tue, 12 Feb 2013 07:00:00 UT

Identity Values – Two things to know

Fri, 08 Jan 2010 07:00:00 UT

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

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Indexing HierarchyID

Thu, 03 Sep 2009 06:00:00 UT

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

Replication – Accommodating Application Inserts

Wed, 19 Aug 2009 06:00:00 UT

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

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

Thu, 13 Aug 2009 06:00:00 UT

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