GSquared (5/13/2008)

---

GilaMonster (5/13/2008)

---

I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add...

GilaMonster (5/13/2008)

---

I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the...

greats, thxs for the reply!

I think should be hundreds thousand monthly? why?

Not 2.1 billions in one table . Column ID (with identity) seems to be overrflow (because it hit overrflow issue, thus i think it's deleted , not trucated)

this table is...

replication is used, but the data is more than 2,147,483,647 (size of int) less than several months (big int will be using), so will need something like partitioning to speed...

I also think about table partitioning in MSSQL 2005, by using date as partition (see my previous post here) But is that the actual purpose of table partitioning??

Maybe can try EncryptByKey if MSSQL 2005, if really want?

bert (5/6/2008)

---

Many SQL users do...

if there's no conversion, can try from MS Enterprise Manager(same for MSSQL 2005)? go to design mode, select the column want to change, you will find the "Save chnages to...

From what I know, SQLCEDataAdapter has performance issue, it drains the memory fast. since you are using sql CE 3.0, why don't you use SqlCeResultSet Class . Here's a another...

DO you think this: System.Data.Common Namespace is workable?

Select name, Category =

CASE xType

WHEN 'P'THEN 'Stored procedure'

WHEN 'TR'THEN 'Trigger'

WHEN 'V'THEN 'View'

WHEN 'U'THEN 'User table'

WHEN 'TF'THEN 'Table function'

ELSE 'Not yet categorized'

...

Can try to format it instead of depend on Reginonal Setting or Server configuration?

http://sqlserver2000.databases.aspfaq.com/can-i-make-sql-server-format-dates-and-times-for-me.html

Should be something like this (http://msdn2.microsoft.com/en-us/library/aa258235(SQL.80).aspx) ?

USE pubs

GO

SELECT Category =

CASE type

WHEN 'popular_comp'...