n_parker (2/9/2009)

---

Almost there!!!! Thank you gsquared!

I have:

select ver AS TOPVER from mytable

where partnumber = 'P7029'

order by len(ver) desc, substring(ver, 1, 1) desc, substring(ver, 2, 1) desc

which works and...

milan (2/9/2009)

---

Hi,

I have a got two tables and the relation is one to many - meaning a single entry in the main table will have exact 12 records in the...

Vijaya Kadiyala (2/9/2009)

---

Thats really a good tip. This will work if you are creating a new table.

What if the table already exists, so in this case we have to use...

Usually network overhead is very little (negligible) unless the amount of data is very large.

You can *still* use rowmodcntr from sysindexes compatibility view.

It now changes not only with "row" but also "column" changes.

There were some cases I had to deal with situations similar to this.

Suppose (as in this case) your DB is small.

Instead of dropping the tables you could have staging tables...

Maria,

You *MUST* use the exact server name that pops up on it when you run

SELECT @@servername

I am here with DaveB.

"IF" you can use Log-shipping, you should!

As Long as you are not changing the schema. I believe the 'sync' jobs should apply the "diff" and not drop+create the tables entirely.

There are many solutions that can be...

TRACEY (2/9/2009)

---

I replicate database A to SERVER B database B

Would it be recommened to run the udpate statistics on the database B.

I normally don't run on the replicated database. ...

If you run:

select sum( character_octet_length)

from information_schema.columns

where table_name ='LEAD'

and data_type not in('ntext','text','image' )

and character_maximum_length is not null

the maximum size...

That is only going to "hide" the problem

Do you really need NVARCHAR instead of VARCHAR ?

In addition it looks like you need normalization (a lot) on that table.

gharris_35 (2/9/2009)

---

1. SP3 has been installed

2. Here is the DDL for the unchanged table:

CREATE TABLE [dbo].[Lead](

[Lead_LeadID] [int] NOT NULL,

[Lead_CreatedBy] [int] NULL,

[Lead_CreatedDate] [datetime] NULL,

[Lead_UpdatedBy] [int] NULL,

[Lead_UpdatedDate] [datetime] NULL,

[Lead_TimeStamp] [datetime] NULL,

[Lead_Deleted] [int]...

Can you post the DDL ?