Viewing 15 posts - 16 through 30 (of 95 total)
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...
March 4, 2004 at 7:55 am
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...
March 4, 2004 at 7:21 am
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...
March 3, 2004 at 3:19 pm
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...
March 3, 2004 at 1:51 pm
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...
February 20, 2004 at 6:55 am
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"...
February 10, 2004 at 8:04 am
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...
November 13, 2003 at 2:02 pm
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...
November 12, 2003 at 1:31 pm
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...
November 12, 2003 at 1:20 pm
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...
November 10, 2003 at 12:34 pm
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...
November 5, 2003 at 1:31 pm
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.
November 5, 2003 at 1:18 pm
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...
November 5, 2003 at 8:11 am
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...
November 5, 2003 at 6:51 am
Viewing 15 posts - 16 through 30 (of 95 total)