finally the execution plan on my live database

I can post the plans that run against my live data tomorrow as well 🙂

As posted earlier I >presumed< it would...

sorry it took me so long.

Here you have the execution plan with all there query-versions

Hi,

Performance was just a presumption. The execution plans don't differ in tasks, however the estimation is 48% to 52% if you estimate them together.

Moving the collation doesn't make difference

Hi,

COLLATE to BIN works fine.

I guess it is not quite a performance-booster to change the collation while using LIKE.

So is it a...

sorry, I did not get the notification of your reply.

Mark-101232 (7/20/2011)

---

Not entirely sure if it's a bug or not, but I think it's to do with the expansion of [A-Z]....

YEAR and MONTH are not my main query parts, just gave an example how I tried to make the querie more expensive.

But you are right about that I will use...

don't get me wrong. I am in favour of using the datetype for dates,

I just want to know if anyone made bigger test with those types before I move in...

Thx guys.

I would like to avoid a new tool for our customers.

Does anyone know if Sharepoint 2010 Performancepoint Services would make any difference? or the PowerPivot Component of excel 2010?

Did someone find a solution to this problem?

sorry, no 😉

The Export-Format should be shown in the Format Column.

CSV

EXCEL

IMAGE

MHTML

PDF

RPL

WORD

XML

Take a look in the definition of the View ExecutionLog2

CASE(Source)

WHEN 1 THEN 'Live'

WHEN 2 THEN 'Cache'

WHEN 3 THEN 'Snapshot'

WHEN 4 THEN 'History'

WHEN 5 THEN 'AdHoc'

WHEN 6 THEN 'Session'

WHEN 7...

If you view data from a snapshot you get source: 3 - Snapshot and the Format should be "RPL"

Hi there,

you should get that from the Source-Column in the ExecutionLog-Table.

When you create a Snapshot you will get an entry in the Source-Column: 4 = History and the Format will...