(select top 1 peerCity from Peers where peerCity != 'Determining' AND peerCountry != 'NULL' and peerCountryCode = B.peerCountryCode group by peerCity order by count(peerCity) desc) peerTopCity
from Peers B where peerCountryCode != 'NULL' and peerCountry != 'NULL' group by peerCountryCode, peerCountry order by peerTotal desc
This causes the error
but if you take the order by at teh end out, it works. The table is partitioned acrosss 3 bladesBy the way, I am using SP2 CTP|||Source,Severity,Message
01/09/2007 09:06:09,Server,Unknown,A user request from the session with SPID 59 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
01/09/2007 09:06:09,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
01/09/2007 09:06:09,spid59,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
01/09/2007 09:06:09,spid59,Unknown,Stack Signature for the dump is 0x0684EA45
01/09/2007 09:06:09,spid59,Unknown,78132A36 Module(MSVCR80+00002A36)
01/09/2007 09:06:09,spid59,Unknown,781329AA Module(MSVCR80+000029AA)
01/09/2007 09:06:09,spid59,Unknown,0126872D Module(sqlservr+0026872D)
01/09/2007 09:06:09,spid59,Unknown,01268590 Module(sqlservr+00268590)
01/09/2007 09:06:09,spid59,Unknown,01268AE0 Module(sqlservr+00268AE0)
01/09/2007 09:06:09,spid59,Unknown,01267AEF Module(sqlservr+00267AEF)
01/09/2007 09:06:09,spid59,Unknown,0100B1D5 Module(sqlservr+0000B1D5)
01/09/2007 09:06:09,spid59,Unknown,0100B4C5 Module(sqlservr+0000B4C5)
01/09/2007 09:06:09,spid59,Unknown,0100B39F Module(sqlservr+0000B39F)
01/09/2007 09:06:09,spid59,Unknown,0102F3DB Module(sqlservr+0002F3DB)
01/09/2007 09:06:09,spid59,Unknown,01030CC2 Module(sqlservr+00030CC2)
01/09/2007 09:06:09,spid59,Unknown,0102CDE6 Module(sqlservr+0002CDE6)
01/09/2007 09:06:09,spid59,Unknown,012DC2DD Module(sqlservr+002DC2DD)
01/09/2007 09:06:09,spid59,Unknown,013ADAA5 Module(sqlservr+003ADAA5)
01/09/2007 09:06:09,spid59,Unknown,012DB9B7 Module(sqlservr+002DB9B7)
01/09/2007 09:06:09,spid59,Unknown,012DC028 Module(sqlservr+002DC028)
01/09/2007 09:06:09,spid59,Unknown,012DD905 Module(sqlservr+002DD905)
01/09/2007 09:06:09,spid59,Unknown,012DD7A0 Module(sqlservr+002DD7A0)
01/09/2007 09:06:09,spid59,Unknown,012DCEA7 Module(sqlservr+002DCEA7)
01/09/2007 09:06:09,spid59,Unknown,012DDBA3 Module(sqlservr+002DDBA3)
01/09/2007 09:06:09,spid59,Unknown,012E13A8 Module(sqlservr+002E13A8)
01/09/2007 09:06:09,spid59,Unknown,013C92D9 Module(sqlservr+003C92D9)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,01415594 Module(sqlservr+00415594)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,01454E39 Module(sqlservr+00454E39)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,0141A804 Module(sqlservr+0041A804)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,01418E23 Module(sqlservr+00418E23)
01/09/2007 09:06:09,spid59,Unknown,013C9B43 Module(sqlservr+003C9B43)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,0141B6BE Module(sqlservr+0041B6BE)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,01415594 Module(sqlservr+00415594)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,01415E6E Module(sqlservr+00415E6E)
01/09/2007 09:06:09,spid59,Unknown,013C9B43 Module(sqlservr+003C9B43)
01/09/2007 09:06:09,spid59,Unknown,013C8AE9 Module(sqlservr+003C8AE9)
01/09/2007 09:06:09,spid59,Unknown,01EBFF7D Module(sqlservr+00EBFF7D)
01/09/2007 09:06:09,spid59,Unknown,0151F41F Module(sqlservr+0051F41F)
01/09/2007 09:06:09,spid59,Unknown,013B6A49 Module(sqlservr+003B6A49)
01/09/2007 09:06:09,spid59,Unknown,013B6891 Module(sqlservr+003B6891)
01/09/2007 09:06:09,spid59,Unknown,* Short Stack Dump
01/09/2007 09:06:09,spid59,Unknown,* -
01/09/2007 09:06:09,spid59,Unknown,* *******************************************************************************
01/09/2007 09:06:09,spid59,Unknown,* SegSs: 00000023:
01/09/2007 09:06:09,spid59,Unknown,* Esp: 63CCB9FC: 63CC1102 21E257A8 21E7D930 21C9E3E8 63CCBA40 02490881
01/09/2007 09:06:09,spid59,Unknown,* EFlags: 00010246: 006F0064 00730077 004E005F 00000054 00610050 00680074
01/09/2007 09:06:09,spid59,Unknown,* SegCs: 0000001B:
01/09/2007 09:06:09,spid59,Unknown,* Ebp: 63CCBA18: 63CCBA4C 013B6A49 21E7D930 00000000 21E257A8 63CC1156
01/09/2007 09:06:09,spid59,Unknown,* Eip: 013B6891: 5BD9A5F3 3843893C C7404389 FFFFFC45 C38BFFFF 64F44D8B
01/09/2007 09:06:09,spid59,Unknown,* Edx: 00000000:
01/09/2007 09:06:09,spid59,Unknown,* Ecx: 00000008:
01/09/2007 09:06:09,spid59,Unknown,* Ebx: 21E7D930: 013B68C0 00000000 0000006D 21E257A8 00000000 00000000
01/09/2007 09:06:09,spid59,Unknown,* Eax: 00000000:
01/09/2007 09:06:09,spid59,Unknown,* Esi: 00000000:
01/09/2007 09:06:09,spid59,Unknown,* Edi: 21E7D948: 00000000 00000000 00000000 00000000 00000000 00000000
01/09/2007 09:06:09,spid59,Unknown,*
01/09/2007 09:06:09,spid59,Unknown,* dbghelp 64330000 64444FFF 00115000
01/09/2007 09:06:09,spid59,Unknown,* xplog70 63B30000 63B32FFF 00003000
01/09/2007 09:06:09,spid59,Unknown,* xplog70 63B10000 63B1BFFF 0000c000
01/09/2007 09:06:09,spid59,Unknown,* xpstar90 63AE0000 63B05FFF 00026000
01/09/2007 09:06:09,spid59,Unknown,* odbcint 63AC0000 63AD6FFF 00017000
01/09/2007 09:06:09,spid59,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
01/09/2007 09:06:09,spid59,Unknown,* BatchParser90 63990000 639AEFFF 0001f000
01/09/2007 09:06:09,spid59,Unknown,* ODBC32 63950000 6398CFFF 0003d000
01/09/2007 09:06:09,spid59,Unknown,* SQLSCM90 63930000 63938FFF 00009000
01/09/2007 09:06:09,spid59,Unknown,* xpstar90 638D0000 63918FFF 00049000
01/09/2007 09:06:09,spid59,Unknown,* xpsqlbot 638B0000 638B5FFF 00006000
01/09/2007 09:06:09,spid59,Unknown,* msftepxy 633C0000 633D4FFF 00015000
01/09/2007 09:06:09,spid59,Unknown,* SQLNCLIR 00770000 007A2FFF 00033000
01/09/2007 09:06:09,spid59,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
01/09/2007 09:06:09,spid59,Unknown,* COMCTL32 77530000 775C6FFF 00097000
01/09/2007 09:06:09,spid59,Unknown,* sqlncli 63010000 63233FFF 00224000
01/09/2007 09:06:09,spid59,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
01/09/2007 09:06:09,spid59,Unknown,* xpsp2res 62D40000 63004FFF 002c5000
01/09/2007 09:06:09,spid59,Unknown,* ntdsapi 766F0000 76704FFF 00015000
01/09/2007 09:06:09,spid59,Unknown,* SAMLIB 62D30000 62D3EFFF 0000f000
01/09/2007 09:06:09,spid59,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
01/09/2007 09:06:09,spid59,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
01/09/2007 09:06:09,spid59,Unknown,* hnetcfg 62CD0000 62D28FFF 00059000
01/09/2007 09:06:09,spid59,Unknown,* dssenh 68100000 68123FFF 00024000
01/09/2007 09:06:09,spid59,Unknown,* imagehlp 76C10000 76C38FFF 00029000
01/09/2007 09:06:09,spid59,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
01/09/2007 09:06:09,spid59,Unknown,* dbghelp 62950000 62A64FFF 00115000
01/09/2007 09:06:09,spid59,Unknown,* msfte 626F0000 62948FFF 00259000
01/09/2007 09:06:09,spid59,Unknown,* security 61F50000 61F53FFF 00004000
01/09/2007 09:06:09,spid59,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
01/09/2007 09:06:09,spid59,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
01/09/2007 09:06:09,spid59,Unknown,* winrnr 76F70000 76F76FFF 00007000
01/09/2007 09:06:09,spid59,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
01/09/2007 09:06:09,spid59,Unknown,* RESUTILS 344B0000 344C2FFF 00013000
01/09/2007 09:06:09,spid59,Unknown,* CLUSAPI 34490000 344A1FFF 00012000
01/09/2007 09:06:09,spid59,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
01/09/2007 09:06:09,spid59,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
01/09/2007 09:06:09,spid59,Unknown,* VERSION 77B90000 77B97FFF 00008000
01/09/2007 09:06:09,spid59,Unknown,* MTXCLU 34470000 34488FFF 00019000
01/09/2007 09:06:09,spid59,Unknown,* msvcp60 780C0000 78120FFF 00061000
01/09/2007 09:06:09,spid59,Unknown,* MSDTCPRX 343F0000 34467FFF 00078000
01/09/2007 09:06:09,spid59,Unknown,* XOLEHLP 343E0000 343E5FFF 00006000
01/09/2007 09:06:09,spid59,Unknown,* COMRES 77010000 770D5FFF 000c6000
01/09/2007 09:06:09,spid59,Unknown,* schannel 76750000 76776FFF 00027000
01/09/2007 09:06:09,spid59,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
01/09/2007 09:06:09,spid59,Unknown,* kerberos 34320000 34377FFF 00058000
01/09/2007 09:06:09,spid59,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
01/09/2007 09:06:09,spid59,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
01/09/2007 09:06:09,spid59,Unknown,* ole32 77670000 777A3FFF 00134000
01/09/2007 09:06:09,spid59,Unknown,* MSCOREE 340C0000 34104FFF 00045000
01/09/2007 09:06:09,spid59,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
01/09/2007 09:06:09,spid59,Unknown,* rsaenh 68000000 6802EFFF 0002f000
01/09/2007 09:06:09,spid59,Unknown,* SQLOS 344D0000 344D4FFF 00005000
01/09/2007 09:06:09,spid59,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
01/09/2007 09:06:09,spid59,Unknown,* instapi 48060000 48069FFF 0000a000
01/09/2007 09:06:09,spid59,Unknown,* psapi 76B70000 76B7AFFF 0000b000
01/09/2007 09:06:09,spid59,Unknown,* comctl32 77420000 77522FFF 00103000
01/09/2007 09:06:09,spid59,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
01/09/2007 09:06:09,spid59,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
01/09/2007 09:06:09,spid59,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
01/09/2007 09:06:09,spid59,Unknown,* opends60 333E0000 333E6FFF 00007000
01/09/2007 09:06:09,spid59,Unknown,* USERENV 76920000 769E3FFF 000c4000
01/09/2007 09:06:09,spid59,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
01/09/2007 09:06:09,spid59,Unknown,* WS2_32 71C00000 71C16FFF 00017000
01/09/2007 09:06:09,spid59,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
01/09/2007 09:06:09,spid59,Unknown,* Secur32 76F50000 76F62FFF 00013000
01/09/2007 09:06:09,spid59,Unknown,* MSASN1 76190000 761A1FFF 00012000
01/09/2007 09:06:09,spid59,Unknown,* CRYPT32 761B0000 76242FFF 00093000
01/09/2007 09:06:09,spid59,Unknown,* GDI32 77C00000 77C47FFF 00048000
01/09/2007 09:06:09,spid59,Unknown,* USER32 77380000 77411FFF 00092000
01/09/2007 09:06:09,spid59,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
01/09/2007 09:06:09,spid59,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
01/09/2007 09:06:09,spid59,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
01/09/2007 09:06:09,spid59,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
01/09/2007 09:06:09,spid59,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
01/09/2007 09:06:09,spid59,Unknown,* kernel32 77E40000 77F41FFF 00102000
01/09/2007 09:06:09,spid59,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
01/09/2007 09:06:09,spid59,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
01/09/2007 09:06:09,spid59,Unknown,* MODULE BASE END SIZE
01/09/2007 09:06:09,spid59,Unknown,*
01/09/2007 09:06:09,spid59,Unknown,*
01/09/2007 09:06:09,spid59,Unknown,* ry order by peerTotal desc
01/09/2007 09:06:09,spid59,Unknown,* != 'NULL' and peerCountry != 'NULL' group by peerCountryCode<c/> peerCount
01/09/2007 09:06:09,spid59,Unknown,* y) desc) peerTopCity from divinityTorrentPeers B where peerCountryCode
01/09/2007 09:06:09,spid59,Unknown,* CountryCode = B.peerCountryCode group by peerCity order by count(peerCit
01/09/2007 09:06:09,spid59,Unknown,* Peers where peerCity != 'Determining' AND peerCountry != 'NULL' and peer
01/09/2007 09:06:09,spid59,Unknown,* ountryCode<c/> B.peerCountry<c/> (select top 1 peerCity from Torrent
01/09/2007 09:06:09,spid59,Unknown,* SET XACT_ABORT ON; select top 10 count(*) peerTotal<c/> B.peerC
01/09/2007 09:06:09,spid59,Unknown,* Input Buffer 510 bytes -
01/09/2007 09:06:09,spid59,Unknown,* Access Violation occurred reading address 00000000
01/09/2007 09:06:09,spid59,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
01/09/2007 09:06:09,spid59,Unknown,* Exception Address = 013B6891 Module(sqlservr+003B6891)
01/09/2007 09:06:09,spid59,Unknown,*
01/09/2007 09:06:09,spid59,Unknown,*
01/09/2007 09:06:09,spid59,Unknown,* Private server build.
01/09/2007 09:06:09,spid59,Unknown,* 01/09/07 09:06:09 spid 59
01/09/2007 09:06:09,spid59,Unknown,* BEGIN STACK DUMP:
01/09/2007 09:06:09,spid59,Unknown,*
01/09/2007 09:06:09,spid59,Unknown,* *******************************************************************************|||Hmm.. I am also getting this error, even after installing the new Sp2 CTP patch.... this is bad that no one has even responded to this yet..
