Please don't duplicate posts. It only fragments replies. Please direct replies to http://www.sqlservercentral.com/Forums/Topic1828586-3411-1.aspx.

Rechana Rajan (10/23/2016)

---

Eirikur Eiriksson (10/23/2016)

---

Ed Wagner (10/23/2016)

---

Eirikur Eiriksson (10/23/2016)

---

Rechana Rajan (10/23/2016)

---

We are creating a data archive plan for one oof our big table which have more than 8 million records...

Eirikur Eiriksson (10/23/2016)

---

Rechana Rajan (10/23/2016)

---

We are creating a data archive plan for one oof our big table which have more than 8 million records in jusst 8 months ....

For your clustered index, consider an artificial key - an Integer Identity column. Because you can schedule rooms in the future, they won't be inserted in order by date.

I...

Eirikur Eiriksson (10/23/2016)

---

The error is pointing to the LISTAGG_CLOB as (as far as I can remember) there is no such function in Oracle. Chances are that it exists as something...

office 74070 (10/11/2016)

---

Hey guys,

i become following error during report rendering on a sharepoint intergrated ssrs mode:

Fehler bei der Berichtsverarbeitung. (rsProcessingAborted)

Fehler beim Ausführen der Abfrage für das DataSet1-Dataset. (rsErrorExecutingCommand)

ORA-00904: "LISTAGG_CLOB": ungültiger...

I'm a bit puzzled by the "if you really, really need to performance test" part. Who doesn't do performance tests before releasing something to production? It's a part...

Eirikur Eiriksson (10/22/2016)

---

patelxx (10/22/2016)

---

Many Thanks for the reply - it really worked for my results set, please can explain the below section of the code for my understanding:

NUMBERED_INSTANCES AS

(

...

Wine

TomThomson (10/21/2016)

---

Me too. I thought SQL Server would...

Sean Lange (10/21/2016)

---

Yes indeed. The website for our soccer club was down for about the half the day today. I kept receiving...

Lynn Pettis (10/21/2016)

---

Ed Wagner (10/21/2016)

---

TomThomson (10/21/2016)

---

David.Poole (10/17/2016)

---

I was aghast to find an old Clipper app still being maintained, although it didn't really need much maintaining. For next to no...

Cooper

Ray K (10/21/2016)

---

Ed Wagner (10/21/2016)

---

Whatever you do, please don't quit that Disaster Documents session. I really wanted to see it in Pittsburgh, but helped out with the WBADBA track...

An index rebuild is a fully logged operation.

Your clustering key is 62 bytes wide and you have 1.2B rows. That's just the data that gets distributed across the non-leaf...