I'm guessing that ProductID column is an INT data type?

So the first query is doing an implicit data conversion to INT ("CONVERT_IMPLICIT(int,[@1],0)") on the value, as 1 could be any...

No worries Jeff theres no rush, the code has been running for around a year within the expected parameters. I also know what its like especially if things get...

Thank you to both of the replies so far its confirmed a few things, and given me a few things to ponder.

The PK is Non-clustered on the #Lookup table, and...

sestell1 (8/6/2012)

---

I mostly use CTE's to generate a specific number of ordered rows.

This is something I would need for example when:

I want to return a row for every day within...

I think you might find that SQL server is doing an implicit cast to an Int, I've see this at times when comparing numeric strings and Integers,

If you take...

Jason-299789 (7/25/2012)

---

I'd like to know if theres any way to clear out the dmv stats tables as I want to start with a fresh set of stats in order to...

Hi Jeff,

I agree the limit of 12 levels is a bit of problem, however it can be extended if needed with a change to the Temptable and final pivot, but...

Isnt this trying to use the Jet drivers which arent available on x64 environments.

Jeff as per my last message, this is the DDL for the SP and source Table FND_FLEX_VALUE_NORM_HIERARCHY as well as the Execution plans and IO/Timing Stats

Just a little explanation of...

Hi Jeff,

Sorry for the delay, works been quite hectic as we try and clear the decks as much as possible before the Olympic chaos hits london.

The reason was that we...

Firstly are you connecting to a network that is external to the Corporate network? or is it part of of the corporate network that is just locatd Remotely.

In either case...

gert,

That sounds wrong, I doubt SSD's would be treat any differently to traditional drives when putting them in a raid array.

If im wrong I'd love to know...

Very useful information, and working and OLAP Db's I've often considered read performance to be of higher importance than write performance.

The reason for this is that you are generally write...

Have you thought about creating a calculated column using the BINARY_CHECKSUM on the table with to save on creating an additional view.

Cadavre,

While Gail mentions the use of the RECOMPILE hint she does so in 6 lines at the very bottom of part 2, but doesnt go into the implications which is...