Здравствуйте,
Другими словами, имеет ли смысл покупать полный SQL 2005 (8).
Режим скорее всего "Выборки".
Я как-то даже трассировал зпросы к БД, наблюдал нечто монструозное:
SELECT DISTINCT
p.PRJ_ID,
p.PRJTREE_ID,
p.PRJ_NAME,
p.PRJ_NOTE,
p.PRJ_COMMENT,
p.PRJ_HAVEPRJ,
r.ROUTING_ID,
r.ROUTING_NOTE,
pt.PRJTYPE_ID,
pt.PRJTYPE_NOTE,
pt.PRJTYPE_ICO,
pv.PRJVER_ID,
pv.START_STATE_ID,
pv.FINISH_STATE_ID,
pv.PRJVER_NAME,
pv.PRJVER_NUMBER,
pv.PRJVER_REM,
pv.PRJVERSTATE_ID,
pv.PRJVER_ACT,
pv.PRJVER_LOCKED_BY,
pvs.PRJVERSTATE_NAME,
pvs.TCS_ACCESS,
PVAF.filetype_id,
pv.CREATOR,
pv.CREATE_DATE,
pv.CHANGER,
pv.CHANGE_DATE,
LOCKUSR.USER_NAME as LOCKUSR_NAME,
CR_USER.USER_NAME as CR_USERNAME
,
PV0.prjpar_string_value as PVF0,
PV1.prjpar_string_value as PVF1,
PV2.prjpar_date_value as PVF2,
PV3.prjpar_int_value as PVF3,
PV4.prjpar_date_value as PVF4,
PV5.prjpar_int_value as PVF5,
PV6.prjpar_int_value as PVF6,
PV7.prjpar_int_value as PVF7,
PV8.prjpar_int_value as PVF8,
PV9.prjpar_int_value as PVF9,
PV10.prjpar_int_value as PVF10,
PV11.prjpar_string_value as PVF11,
PV12.prjpar_string_value as PVF12,
PV13.prjpar_string_value as PVF13,
PV14.prjpar_float_value as PVF14,
PV15.prjpar_float_value as PVF15,
PV16.prjpar_float_value as PVF16,
PV17.prjpar_float_value as PVF17,
PV18.prjpar_float_value as PVF18,
PV19.prjpar_float_value as PVF19,
PV20.prjpar_string_value as PVF20,
PV21.prjpar_float_value as PVF21,
PV22.prjpar_string_value as PVF22
FROM
PROJECTS p
INNER JOIN PRJTYPES pt ON p.PRJTYPE_ID = pt.PRJTYPE_ID
INNER JOIN ROUTING r ON p.ROUTING_ID = r.ROUTING_ID
INNER JOIN PRJVERSION pv ON p.PRJ_ID = pv.PRJ_ID
INNER JOIN PRJVERSTATES pvs ON pv.PRJVERSTATE_ID = pvs.PRJVERSTATE_ID
INNER JOIN USERS CR_USER ON pv.CREATOR = CR_USER.USER_ID
LEFT JOIN USERS LOCKUSR ON pv.PRJVER_LOCKED_BY = LOCKUSR.USER_ID
LEFT JOIN PRJVERACTFILE PVAF ON PVAF.prjver_id=PV.prjver_id
INNER JOIN PRJTREETYPE_ACCESS ptta ON p.PRJTREETYPE_ID = ptta.PRJTREETYPE_ID
LEFT JOIN PRJPARVALUES_EX PV0 ON PV0.PRJPAR_ID=30 AND PV0.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV1 ON PV1.PRJPAR_ID=35 AND PV1.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV2 ON PV2.PRJPAR_ID=52 AND PV2.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV3 ON PV3.PRJPAR_ID=33 AND PV3.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV4 ON PV4.PRJPAR_ID=53 AND PV4.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV5 ON PV5.PRJPAR_ID=34 AND PV5.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV6 ON PV6.PRJPAR_ID=40 AND PV6.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV7 ON PV7.PRJPAR_ID=41 AND PV7.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV8 ON PV8.PRJPAR_ID=42 AND PV8.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV9 ON PV9.PRJPAR_ID=43 AND PV9.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV10 ON PV10.PRJPAR_ID=44 AND PV10.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV11 ON PV11.PRJPAR_ID=37 AND PV11.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV12 ON PV12.PRJPAR_ID=39 AND PV12.PRJVER_ID=PV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV13 ON PV13.PRJPAR_ID=59 AND PV13.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV14 ON PV14.PRJPAR_ID=45 AND PV14.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV15 ON PV15.PRJPAR_ID=54 AND PV15.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV16 ON PV16.PRJPAR_ID=46 AND PV16.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV17 ON PV17.PRJPAR_ID=56 AND PV17.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV18 ON PV18.PRJPAR_ID=48 AND PV18.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV19 ON PV19.PRJPAR_ID=47 AND PV19.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV20 ON PV20.PRJPAR_ID=63 AND PV20.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV21 ON PV21.PRJPAR_ID=57 AND PV21.PRJVER_IDV.PRJVER_ID
LEFT JOIN PRJPARVALUES_EX PV22 ON PV22.PRJPAR_ID=62 AND PV22.PRJVER_IDV.PRJVER_ID WHERE
(ptta.TCS_ACCESS > 0) AND (ptta.USER_ID=1423)
AND (PV.CREATE_DATE>='11/01/2009')
AND ((PRJTYPE_NOTE collate Cyrillic_General_CI_AS)='IA??A-CAAAIEA')
AND ((NOT PV0.PRJPAR_ID IS NULL) OR
(NOT PV1.PRJPAR_ID IS NULL) OR
(NOT PV2.PRJPAR_ID IS NULL) OR
(NOT PV3.PRJPAR_ID IS NULL) OR
(NOT PV4.PRJPAR_ID IS NULL) OR
(NOT PV5.PRJPAR_ID IS NULL) OR
(NOT PV6.PRJPAR_ID IS NULL) OR
(NOT PV7.PRJPAR_ID IS NULL) OR
(NOT PV8.PRJPAR_ID IS NULL) OR
(NOT PV9.PRJPAR_ID IS NULL) OR
(NOT PV10.PRJPAR_ID IS NULL) OR
(NOT PV11.PRJPAR_ID IS NULL) OR
(NOT PV12.PRJPAR_ID IS NULL) OR
(NOT PV13.PRJPAR_ID IS NULL) OR
(NOT PV14.PRJPAR_ID IS NULL) OR
(NOT PV15.PRJPAR_ID IS NULL) OR
(NOT PV16.PRJPAR_ID IS NULL) OR
(NOT PV17.PRJPAR_ID IS NULL) OR
(NOT PV18.PRJPAR_ID IS NULL) OR
(NOT PV19.PRJPAR_ID IS NULL) OR
(NOT PV20.PRJPAR_ID IS NULL) OR
(NOT PV21.PRJPAR_ID IS NULL) OR
(NOT PV22.PRJPAR_ID IS NULL))
AND(PV2.prjpar_date_value>='11/01/2009'/*attr*/)
ORDER BY PV.CREATE_DATE DESC