Jo Pattyn

Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 2,043 total)

RE: SQL Server V7 Support

see
http://support.microsoft.com/lifecycle/search/
for life cycle management of microsoft products.
General support for sql server 7 will end at the first of 2006.

General support site for sql server
http://www.microsoft.com/sql/support/default.mspx

September 15, 2005 at 11:16 am

#590255
RE: Pre-Windows 2000 Compatible Access Group
1)What is Windows 2000 Compatible Access Group ?
2)Sql server version:
```
SELECT @@VERSION
```
or
xp_msver (see books on line)
September 15, 2005 at 11:04 am

#590247
RE: Causes of Nonlogged Operations...

what recovery model are you using (full, simple, bulk)?
Truncate table isn't logged
The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table. It is almost...

September 14, 2005 at 3:18 pm

#589939
RE: SQL Server and Oracle Max User capacity?

This question has many answers.
The number of users mostly depends on your hardware/ quality of software.
A quick internet searching gives a try to compare sql server 2000 vs oracle 9

September 14, 2005 at 3:11 pm

#589933
RE: OPTION (KEEPFIXED PLAN) issue

SELECT
CF.FileId
,CF.Transid
From #UsFavs UF WITH (NOLOCK INDEX=IDX_2)
, Cus_file CF WITH (NOLOCK)
Where
UF.Transid = CF.Transid
ORDER BY P.LastNm,P.FirstNm
I'm not familiar with NOLOCK clauses, but
Why...

September 14, 2005 at 2:53 pm

#589924
RE: Help with a Select - can''''t see the trees for the splinters at the moment!

In case you can store some profiles (either permanent or temporary) to store all the requirements
profile_qualifications:
profileid
qualificationid
required /*required might be weighted like 0 or -1 (@MyconstantforRequired
) for required, >(=)0 for non-required*/
/*Variables :

September 14, 2005 at 12:08 pm

#589842

RE: trigger firing order

I wouldn't rely much on the order of triggers. Rather have it in one.

You have first, last, and between (with no order)

September 14, 2005 at 11:23 am

#589828

RE: Help with a Select - can''''t see the trees for the splinters at the moment!

not as versatile

select MustHave.candidateid,NiceToHave.Extras

from

(

select candidateid

from dbo.Candidate_Qualifications Candidate_Qualifications

where qualificationid = A

OR qualificationid=B

OR qualificationid=C

group by candidateid

having count(QualificationID)=3 /*COUNT 3 = have A,B,C*/

) AS MustHave

left join /*All of musthave, Nice to have if...

September 13, 2005 at 2:40 pm

#589513

RE: Add/update/delete data

I would save your changes in the local dataset, and modify the insert/update/delete commands of the dataset to use your stored procedures to insert/update/delete.

September 13, 2005 at 2:21 pm

#589510