Any One?

Yeah I know as COUNT(ColName) eliminates Null values.

Any pointers?

-Jay

That's what it seems like to me. I am running above mentioned queries.

Now I ran a Query

Select count(*) from Table_name where column_1 is not null.

Column_1 is a NON Null column on the Table. I get count of 56,000,000 which mirrors...

When I do >> select * INTO NEW_TABLE from Table_Name, The count in NEW_TABLE is 56,000,000

So, count(*)...

Is there a way to find if things are out of sync and also why are the out of sync.

Thanks,

Jay

No backups. Any other way?

Thanks.

Code is processing over 700 million records (also joins 10 different tables with over 100 million records in each table) so I think 4 hours is pretty good.

Jeff Moden (7/13/2008)

---

Just...

Thanks for your reply. But, stored procedure should run on the Server and not be limited by SSIS memory and should be using SQL server memory, right?

Thanks.

Thanks.

Thanks for your reply.

We have a 8 CPU Server and MAXDOP is set to 0 which should mean 8 (# of CPU's)??

This is what I see

CXPACKET1462255

PAGEIOLATCH_SH186881

CLR_AUTO_EVENT172800

BACKUPBUFFER165778

SQLTRACE_BUFFER_FLUSH118222

MSQL_XP50448

BACKUPIO37861

ASYNC_IO_COMPLETION34657

BROKER_TASK_STOP30314

LATCH_EX12341

What do these mean?

Thanks.

Marios Philippopoulos (3/16/2008)

---

qwerty qaz (3/15/2008)

---

What's the best way to find if a 64-Bit Windows 2003 based Server is suffering from I/O issues.

I will...

We join multiple tables with over 300 million records to create other tables for reporting purposes. That's why we are thinking of moving Indexes and Temp DB on Local drive...

Thank You will try this.

Thanks for you reply. But, my requirement is little different. We are writing a application which will be given to our tech guys and they will specify the Source DB/Server...