Matt Miller (6/20/2008)

---

GSquared (6/20/2008)

---

Select count(0) doesn't have to get any column metadata. Select count(*) does have to gather column names. It's a very minor difference and won't matter...

Visio could also be your friend 😉

Probably with varchar(max) you are ok. It will slow the query but maybe that is good enoug for what you want.

you must definitely "limit" the Time column with a "range" once you do that you should be fine.

the error is saying you can't put such column in a "GROUP BY"

you won't get minimal logging if the destination table is not empty unless you use TABLOCK and there is only a single clustered index on it. The transaction log size...

you should look at "peer-to-peer" replication

you can mark them as NOT FOR REPLICATION and then publish the tables.

It also depends on how many subscribers you have perpublication. If it is 1-to-1 shared is probably Ok but if it is 1-to-many indepenedent can give you "flexibility" in management.

What about DDL Triggers ?

it is actually UNDER...

ramaanujamr (6/18/2008)

---

Hi All,

I used count to contactid,contact address and i want to total of contact for each contact.

SELECT StudentNo, COUNT(ContactId) AS contact

FROM ...

Probably...

I think Ellis is right:

select name, system_type_id

from sys.types

where system_type_id in (35,99)

name system_type_id

-----------------------

text 35

ntext ...

Matt Miller (6/18/2008)

---

GSquared (6/18/2008)

---

Actually, Joe used ANSI joins. The second query is a cross-join with two Where statements. That's standard.

(Have to admit, I don't like the layout he...