GilaMonster (1/30/2016)

---

kudz (1/29/2016)

---

I tHought of swapping the text field by varchar max but won't work as I have rows with more than 4000 chars and that will be the same...

Thank you both for your quick replies.

The main idea of avoiding activating the row versioning was more the challenge of trying to fix it without the easy way of starting...

Thanks for your help.

I've already looked at the bootstrap setup files and all of them have final resut 'Passed'.

One thing that is particulary weird is that all the .exe files...

Thank you for your help 🙂

I was basically thinking that i had to ignore completely the Date dimension and i thought you would have to analyze the full table and...

Hi there,

Thank you for your reply.

Well .. i don't have any undistributed command , so it seems he is doing his work 🙂

I have an alert set up to tell...

That was the first thing i thought!

I can't trust on what the developer is saying me. 1 year already had passed and he can't be sure if anything(or even...

Hi there,

I know that if I create a Clustered Index, the problem is solved, but I really want to understand the reason of this amout of data wasted.

Avg_fragmentation_in_percent

1.66831921358261

Fragmentation_count

376183

avg_fragment_size_in_pages

1.00009835638506

avg_space_used_in_percent

2.81550531257721 ( WHAT...

I re-created the statement(with a new database) and everything went OK!

But I really can't understand why I'm n0t getting minimal logging in the code posted on the following url:

This is...

Thank you for your reply. As soon as i get to my office I will get all the code I have used and i will post here.

GilaMonster (1/14/2013)

---

Without all...

Thank you!

I was redoing everything you have done in this example but when I restore the log with CONTINUE_AFTER_ERROR I get all my data correctly. I have done this multiple...

I'm still getting the same error 🙁

XML datatype...

Hey mate!

Great idea, however I'm getting this fantastic error :

XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels.

Can you help me ?

Informix doesn't handle very well empty strings.

In our company we use the decode function to substitute the empty strings to NULLS.

decode(field,'',NULL,field) as field

🙂

I would like to find another approach, because...

OK! Now i'm very very very very surprised!

SQLServer returned all the rows in 8 SECONDS!

In Reporting Services is taking more than 1 hour and is using the logical reads that...

GilaMonster, sorry i didnt see your reply .

I'm going to lookup at the statement, and i will return with some more info.

Thanks for your help.

GilaMonster (4/4/2012)

---

As I said, has to...