This is not a complete answer to you question but you can find more information about disk planning at this post and the thread that it is in: http://www.sqlservercentral.com/Forums/FindPost545837.aspx

That cannot possibly be the fault of my code. You will note the lack of a where clause, a...

Brackets ("[ ]") are not a universal substitute for apostrophes (" '...' ") when quoting text. Get rid...

This is not true. It's the total amount of time...

Please define "works" and "does not work".

Michael Earl (8/25/2008)

---

In addition to xp_CmdShell, you have a few other options. Enabling xp_Cmdshell can be a security problem - these other options will be a bit more secure.

1)...

Why not explicitly run statistics on the tables before you start your transaction?

Jason Wisdom (8/25/2008)

---

rbarryyoung (8/25/2008)

---

What do you think the difference...

You know, I had forgotten about this, but you can also setup a Perfmon process to log to SQL Server.

If you set it up to run at system startup and...

It is just something that you write that can run independently of SQL Server.

-...

Todd Engen (8/25/2008)

---

One of the workarounds is to read an entire line is as a single row, then use the Script Component and write your own logic to break it...

Brandie Tarvin (8/25/2008)

---

"The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers...

It is not very clear what you want. Can you give us examples that show your data, what you are currently getting and then what you actually want?

I would suggest that you periodically run a collection agent as a BAT job on the server, but outside of SQL Server that collects this information and then use SQLCMD...

Jason Wisdom (8/25/2008)

---

Steve Jones - Editor (8/25/2008)

---

I don't think you can do this dynamically directly from a job. You can call a stored proc in the job, build the parameter...