Thanks Jack-

My locks are all DB - I guess meaning the whole database. ACK !!

My performance currently is just fine - nothing operates slowly but why is the whole DB...

Ray thanks - and a few questions.

You said

<I've seen heap tables prefer to do a table lock and when clustered allow a key lock>

1)  How do you "See" what locks...

CREATE VIEW dbo.v_Clients

WITH SCHEMABINDING

AS

SELECT

 REL.id_Relationship,

 REL.RelationshipNme,

 LC.id_LogicalClient,

 LC.ID_LogicalClientType,

 CT.TypeNme AS ClientTypeNme,

 LC.LogicalClientNme,

 LC.ID_CommissionGroup,

 ISNULL(COMMS.GroupNamePublic, 'N/A') AS CommissionGroupNme,

 ISNULL(COMMS.GroupNameOperations, 'N/A') AS CommissionGroupOpsNme,

 COUNT(AC.id_Account) AS aAccountCnt, 

 SUM(ISNULL(AC.aHoldingCnt, 0))  AS aHoldingCnt,  -- Percents are based on MARKET Value !!!!

 SUM(ISNULL(AC.aUSDMarketValueAmt, 0)) AS aUSDMarketValueAmt,

 SUM(ISNULL(AC.aUSDAccruedValueAmt, 0)) AS...

I'm familiar with this in general but it doesn't:

1) Tell me what I want to know

2) or - I don't know how to read the output correctly.

I still cannot tell...

Thanks but I'm beyond a basic transform.

Try for yourself - Create one DB connection and then two Transformation tasks going into the same connection.  Se if you can tell which...

Well I'm not sure...

Here's what I have:

2 Connections:

1) A Text File which is the source

2) An OLEDB for SQL Server which is the destination.

Then, I have a "Transform Data Task"...

Hrmmm - interesting....

In a nutshell, To make name searching easy for the users I always append a "%" to the query. So, to find "Bill", they can type "B", or...

Well for me - I'd like my end users to learn how to use a * rather than a % for starters - they're used to a * being a...

Thanks F...

I wonder why the different syntax between LIKE and CONTAINS. I guess LIKE is older and may eventually be replaced by CONTAINS in all searches - Full Text...

Well, for what it's worth, the bigint goes up to 9223372036854775807, which is essentially 19 places. That's an awfully big number. So, even if they change the phone numbers...

Thanks - will review

Jeffo...

Yes,

I have a Clustered index on the BigInt phone column.

I'm actually using 2 tables for this - the key is using a 1 byte TinyInt ID for all my rows...

I'm only dealing with the new "Do Not Call" phone number lists provided by the US States and the US Feds(both provide lists).

No International numbers here.

For clarity - here is my real question.

The CTable is a BIG table that is Never edited. So, I don't want to lock that table at all if I...

Heh-

I like ErasmusJ's comments.

I guess it's really no big deal - just trying to be as clean as possible. Perhaps the searching will be a bt faster as well...