Monday, February 06, 2006

Query Deadlocking itself because of parallelism: OPTION (MAXDOP 1)

ASP.NET 2.0 error in ExecuteQuery:
Transaction (Process ID 71) was deadlocked on thread communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

While execute the following query:
SET NOCOUNT ON
BEGIN
DECLARE @CountOrd int
DECLARE @CustID nvarchar(50)
DECLARE @Start int
DECLARE @End int
DECLARE @Count int
Set @CustID = 'ACD'
Set @Start = 1
Set @End = 25
CREATE TABLE #op(PK int,CountOrd int, Ord int IDENTITY(1,1))
CREATE INDEX op1 ON #op(Ord)

INSERT INTO #op(PK)
SELECT PKID FROM Orders WHERE Orders.OrdStatus <> 'C' AND Orders.OrdStatus <> '0'
And Orders.CustID in (Select Customer From AllowedCustTable(@CustID))
ORDER BY OrdStatus
END

SELECT #op.Ord,od.*,dbo.OrdStrStatus(od.OrdStatus) AS OrdStrStatus
FROM #op LEFT JOIN Orders od ON #op.PK = od.PKID
WHERE #op.Ord BETWEEN @Start AND @End

Select @CountOrd= Count(#op.PK) FROM #op
Set @Count=@CountOrd

DROP TABLE #op


But we can not find any other is access the same table, so probably deadlocking itself because ofparallelism which can happen, try stop parallelism by using MAXDOP 1 onthe OPTIONS clause of the UPDATE/INSERT statement. After change to the following it works:

ORDER BY OrdStatus OPTION (MAXDOP 1)

Saturday, February 04, 2006

Bypass WGA Validation Failure

Microsoft "Genuine Advantage" cracked in 24h: window.g_sDisableWGACheck='all' AV sez, "This week, Microsoft started requiring users to verifiy their serial number before using Windows Update. This effort to force users to either buy XP or tell them where you got the illegal copy is called 'Genuine Advantage.' It was cracked within 24 hours."
Before pressing 'Custom' or 'Express' buttons paste this text to the address bar and press enter:
javascript:void(window.g_sDisableWGACheck='all')
It turns off the trigger for the key check.

==> http://www.boingboing.net/2005/07/28/microsoft_genuine_ad.html

The bug was fixed but new crack here for LegitCheckControl.dll Version 1.5.530.0 by TEAM ETH0==>
http://www.9down.com/search.php?s=Windows+Genuine+Advantage+Validation&module=stories&topic=0&date=0&range=title


Remove Microsoft WGAWarning:
http://www.mydigitallife.info/2006/0...ns-nag-screen/
http://blog.asmemesa.org/?cat=1
简单的方法,可以把以下三个文件的访问权限禁止就可以了:
cacls /d everyone c:\WINDOWS\system32\WgaLogon.dll
cacls /d everyone c:\WINDOWS\system32\WgaTray.exe
cacls /d everyone c:\WINDOWS\system32\LegitCheckControl.dll

=======================================
Win7 Ultimate Key

KH2J9-PC326-T44D4-39H6V-TVPBY
TFP9Y-VCY3P-VVH3T-8XXCC-MF4YK
236TW-X778T-8MV9F-937GT-QVKBB
87VT2-FY2XW-F7K39-W3T8R-XMFGF
J783Y-JKQWR-677Q8-KCXTF-BHWGC
C4M9W-WPRDG-QBB3F-VM9K8-KDQ9Y
2VCGQ-BRVJ4-2HGJ2-K36X9-J66JG
MGX79-TPQB9-KQ248-KXR2V-DHRTD
FJHWT-KDGHY-K2384-93CT7-323RC

6JKV2-QPB8H-RQ893-FW7TM-PBJ73

TFP9Y-VCY3P-VVH3T-8XXCC-MF4YK
KH2J9-PC326-T44D4-39H6V-TVPBY