Quick suggestion for the SQL part of your problem

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @SEEK_PRICE INT = 12

;WITH SAMPLE_DATA (ProdName,MinPrc,MaxPrc) AS

(

SELECT 'Apple' , 10, 15...

Jeff Moden (10/23/2016)

---

Eirikur Eiriksson (10/23/2016)

---

xsevensinzx (10/23/2016)

---

Actually, I slightly disagree with this. I feel conflict happens a lot because people are putting the team first...

xsevensinzx (10/23/2016)

---

Actually, I slightly disagree with this. I feel conflict happens a lot because people are putting the team first over the business. We...

Jeff Moden (10/23/2016)

---

As a bit of a sidebar, I'm concerned for you good folks. One of the indexes you posted appears to have "CardNumber" as a clear text value....

You are most welcome, and please ping back if you have any problems

😎

Super_Grover (10/23/2016)

---

Hi all,

I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...

It appears that first...

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 in jusst 8 months...

mah_j (10/23/2016)

---

I created the filtered covering index on InvoiceUID as you said,(run dbcc freeproccache and dbcc dropcleanbuffers) but it was not usable.Again it uses the IX_invoice index and the...

Rechana Rajan (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 in jusst 8 months...

The problem is still that the query is...

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...

Hi and welcome to the forum.

The EventTime has to be present otherwise the key doesn't hold. The bigger problem here though is the design, i.e. a full day event would...

If I understood correctly then this should do the job

😎

SELECT

TB.OYHSSQ

,TB.OYNMTP

,TB.OYNAME

,TB.OYADD1

,TB.OYADD2

,TB.OYCITY

...

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 . Planning to...

The second execution...