Assuming the original poster meant to load the stuff into a SQL server table rather than into another excel file?

You can ZIP your files and attach...

Hi,

Would you mind sharing your package so that one could have a look who is interested in the above topic?

http://pragmaticworks.com/help/dtsxchange/index.htm#page=FAQ%20-%20What%20are%20the%20advantages_disadvantages%20of%20storing%20SSIS%20packages%20to%20MSDB%20vs%20File%20System.htm

No, I did not.. :unsure:

Dave Ballantyne (10/3/2011)

---

First off , look at the execution plan to see what has happened rather than guessing.

If you are not upto speed , then i would recommend Grants free...

Dave Ballantyne (10/3/2011)

---

They are an *indicator* as are Reads Writes and Cpu usage in a trace session.

But those durations are quite short , so

A) is the quantity of data...

Thanks.

So when do do you usually look at the time stats if it is "not a way of measuring performance at all" ? Thank you.

What does the below query return?

SELECT wait_type, wait_time, last_wait_type

FROM sys.dm_exec_requests

WHERE session_id = 123

1, max 4GB (10GB for 2K8 R2)

2, you can have multiple instances

Understood. Thank you very much!

edited:

And what about the publication dbs?? thank you.

Thanks for your response.

Yeah, but wouldn't that affect replication?

You never worked as a DBA and looking for a junior position? In the meantime you are a MCTS and MCITP?!

How did you do that?? I have around 2 yrs...

What are your index_id and page_count values?

They might be heaps or cointains very few pages. You could look for a better script that ignores heaps and small tables.

colin.Leversuch-Roberts (6/3/2011)

---

sorry I disagree, on a x64 system with 64GB of ram allocating 60GB to sql server is too much. The allocated memory is only for data cache it does...