Jayanth_Kurup (6/22/2011)

---

I was under the assumption that dm_db_partition_stats was accurate , i tried to create a few scenarios where is tot it would be inaccurate but didn't face any problems.

Here's...

its worth noting that this method can still be inaccurate,...

the counts are probably out of date, try running ;

DBCC UPDATEUSAGE

try running your deletes in smaller batches to reduce the table lock,.

using a lock hint is not a great idea, unless you really know what you are doing

without the ddl it is difficult to provide exact code, but something like

Insert into table2 (col1,col2 etc..)

select col1,col2 from table1

where createdate < dateadd(mm,-3,getdate())

with out trying to sound too harsh, your really need to re-develop that code before putting it into production otherwise you open yourself up to a major security...

sounds spot on.

1. create a new table with the columns setup correctly, you can use your current table as a template.

2. copy the data across (select into ) from old table to...

I think you are confusing the issues a little bit here.

for an incremental load you need to have something in the source to define that a record is new or...

you will need to use lookup transformations to add the correct dim key to the fact table.

and as you have some SCDs on your dimensions you will need to use...

Spend $40 (approx) on the dev edition of SQL 2008 it...

localhost is a way of referring to the local server

I find the copy database wizard to be so buggy that it is not really that useful,

others may have had better experience with it, but I would avoid.

In SQL 2008 you can generate scripts that contain both the structure and data, depending on the size of the db this may be the easiest option

Just make sure...

language settings can be login specific, try logging in with the login that is causing issues and run;

SELECT @@Language