I just got done reformatting the proc with SQL Prompt...next stop, comb through it line by line so I understand what it's doing before unleashing it on the world 😀

If...

Ninja's_RGR'us (6/15/2011)

---

A fast san can fill up 30 GB of log in less than 15 minutes.

Sounds like you are doing everything right.

I would check these 2 options out :

What's...

Not much to go on in and I don't use Oracle much these days but here are some random thoughts....

Does the procedure return a result set?

Is it possible you need...

See if this version of TestScript.ps1 is what you're looking for:

<#

3 files are involved

1) File_config.txt - Main file that is in XML format but for this

it is just text...

I agree with homebrew01. It could be any number of things. Please have a careful read through this article and post the actual (not estimated) execution plan from both environments:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

Try putting your cursor in the Expression field and pressing F4.

Make sure EvaluateAsExpression is set to True.

-- good for checking options programmatically

SELECT @@OPTIONS AS user_options ;

GO

--much nicer for humans

DBCC USEROPTIONS ;

GO

Your mask will find files with that name. Did you check to see if the file on disk actually has a space in it?

Phew..happy it got that cleaned...thanks for the info gents.

You don't need to go down the dynamic SQL route unless you have another requirement not stated in your post regarding the use of TRY/CATCH. If you construct your sql...

That's ridiculous :hehe:

How does one get the engine to store -0.00 ?

I tried:

USE test

GO

IF EXISTS ( SELECT *

...

opc.three (6/15/2011)

---

I have not traced the process but will give it a go. I have...

Dave Ballantyne (6/15/2011)

---

Another thought......

Would these functions return an ANSI warning ie "NULL value eliminated from query"

As that may be being 'consumed' somewhere and causing the slow down.

Ive mocked it up...

I have not traced the process but will give it a go. I have an...

Or you can look into using Dynamic Cross Tabs:

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

Similar to how Cross Tabs outperform PIVOTs, a Dynamic Cross Tab process will...