It could be the text-xml is not a valid xml. Try to copy your text XML over to a temp table (column defined as text) and attempt to cast it...

I want to add that delete operations usually introduce a lot of fragmentation, so you should do something to reduce it.

Anyway, I think marking logically deleted records, and then later...

Adi Cohn-120898 (11/18/2013)

---

I don't have any experience that I can share with you, but I can explain why I don't use it. The main reason that I don't like...

1) If you can rebuild your primary non-clustered key to a clustered key, then it'll be better.

If you decide this, then you can do that with ALLOW_ROW_LOCKS = OFF and...

Hi

Is there a clustered index on the table?

Are there any constraints?

You'd better post the table definition with all the constraints...

Regards

IgorMi

The select I caught via the profiler for Indexes usage statistcs is the following:

Select

(dense_rank() over (order by s.name,t.name))%2 as l1

, (dense_rank() over (order by...

In the profiler (Trace properties), check the "Show all columns" and you'll see in the extended columns DatabaseID and DatabaseName. Using them with the filter you can include the desired...

Nice question!

Thanks

Lynn Pettis (11/14/2013)

---

Sean Lange (11/14/2013)

---

IgorMi (11/14/2013)

---

You question is not very clear, but guess what you're asking...

By specifying identity(1,1) primary key, you already have clustered primary key. For the property...

You question is not very clear, but guess what you're asking...

By specifying identity(1,1) primary key, you already have clustered primary key. For the property identity(1,1) there is no need...

Thank you both!

I know that usage of hints should be avoided as much as possible. My thoughts were if in case the stats got out of date the option with...

If i call this function in a queryafter sometime (around 12 hours or some hours) then it takes 1 minutes to fetch 250 data records .. but if i run...

Paul White (11/3/2013)

---

Well it might do,...

Hi All,

Just to inform on this topic. I must have de-installed the sql 2012 RS instance, and then re-create the report sql2008r2 databases in order to run the sql2008r2 RS.

Regards,

IgorMi

Hi

In ssms right click on your database then choose [Tasks] and then [Generate scripts...] will open a window which will lead you to the goal.

Regards,

IgorMi