Oops should have included that the difference is seen more at Insert and Update. Selects and such perform exactly the same.

Actually a PK creates a Unique COnstraint. MS also suggests under "Constraints" in SQL BOL the following

quote:

---

UNIQUE constraints enforce the uniqueness of...

Nevermind I must be smoking today as my brain just didn't pick up the index from previous. No I can now confirm, as a friend of mine would say "I...

I tried everything I can think of with direct inserts and I cannot get my server to duplicate the issues you are having that way.

How are you moving the data,...

That would be good also. Maybe a flag on our profile to mark us as available.

It does boil down to a matter of preference.

Ex. going thru now.

Workforce Management Database

We have a table of SkillSets to Agents and their ranking.

I Would do

Skillset

Agent

Rank

with PK on Agent,Skillset.

Agent...

And a voice from the heavens boomed saying...

"Huh, wha? Oh, are you talking to me."

Sorry just couldn't help myself.

5409045121009 is right on the mark. I tested myself. The question I...

It can be solved. Usually this type of item means a ivot table. The question is it however th values relate. Is it related on item and does item have...

Powerbuilder is fully compatible with the ADO and RDO database access methods as is SQL 2000. However make sure the MDAC installed on the machine is a campatible level (MDAC...

The problem here is Backupo Log just marks the transactions for removal.

Depending on the SQL Version you are running you need to shirnk the file too.

For SQL 2000

DBCC SHRINKFILE the...

I think you are looking for something like this

SELECT

UG.UserGroupID,

UG.UserGroup,

CAST((CASE WHEN UserID IS NULL THEN 0 ELSE 1 END), AS BIT) Selected

FROM

dbname.dbo.UserGroups UG

LEFT JOIN

dbname.dbo.UserGroupRelations UGR

ON

UG.UserGroupID = UGR.UserGroupID

BIT fields are seen as...

Other possibilities could be amoutn of memory insufficient, network bandwidth, other processes, amount of memory on receiving station, and a whole world of others.

To get an idea if it is...

Are you getting an error about needing to grow? How are you sure is full.

I have not seen any issues along this line. Might try unsetting then resetting the option....

I appreciate that Bob but again I must pass that honorable statement on to Robert Marda (rmarda) as I got it from him.

They could do either thru an SP or UDF (if 2000) or within the application submitting to send the data in. However a good programmer will do one way encryption...