.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

KeyHashValue : A lot of duplicate keys

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :



In a table of 26 Miilion rows, I encounter more than 350 duplicate KeyHashValue in one of my indexes. (see below for a sample).

An so I've got a lot of "false lock" issues.


I heard about a modification of the algorithm in SQL Server 2008 R2, but I've got a SQL2008 version only.


Can I find a hotfix for my version of the Database Engine ?


Thanks for your help.



-- (Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)   Sep 16 2010 19:43:16   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) )


use tempdb

create table Test_Hash (Id0 bigint, Id1 int, Id2 bigint, timestamp)

create unique clustered index I_Test_Hash on Test_Hash(Id1,Id0)
create index IX_Test_Hash on Test_Hash(Id1, Id2)

insert into Test_Hash (Id0,Id1,Id2) values (2266487636,1142,2267768303),(2477585784,2498,2458888319)

View Complete Post

More Related Resource Links

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Visual Studio Shortcut Keys

The following tables describe the shortcut keys in the Microsoft Dynamics AX Debugger.

The XML Files: XSLT Keys, Select vs. Match, Conflict Resolution, and More


This month Aaron Skonnard covers how keys work in XSLT, XSLT match and select attributes, SelectNodes order, finding