OPENROWSET expects string literals, you can do this in dynamic sql.

😎

DECLARE @JPGPATH NVARCHAR(MAX) = N'''C:\temp\IMG00001.jpg''';

DECLARE @JPGBIN VARBINARY(MAX) = 0x00;

DECLARE @SQL_STR NVARCHAR(MAX) = REPLACE(N'SELECT * FROM OPENROWSET(BULK {{@JPGPATH}}, SINGLE_BLOB)...

Good question, thanks!

😎

Looks like the performance improvements have more to do with the platform (2014). I have been looking at results from the same (or identical) hardware (E6220, i5, 256GB SSD, 8Gb...

Brilliant:-)

Ran a short disco version of the test on 2014 Developers edition, also added a Lead version which came in second!

SplitterName ...

If the table exist, it could be in another schema. Change the code to (schema_name).[events] if you find it.

😎

I'll be there Friday/Saturday

look out for the one red shoe

😎

Few more numbers (500K rows), queries in the same order as before.

Take note of the high CPU cost of the LEAD function!

😎

Heap, no index,

[font="Courier New"]

(100000 row(s) affected)

Table 'TBL_POLICYHISTORY'. Scan...

This should be pretty close

😎

SELECT distinct CONVERT(DATETIME,arc_endTime,120) AS [Event Time],

arc_destinationHostName AS [Host Name],

arc_destinationUserName AS [User Name],

arc_sourceHostName AS [From Host],

arc_sourceAddress AS [From IP Address],

arc_deviceCustomString2 AS [Database],

arc_deviceCustomString1...

Sean Lange (5/13/2014)

---

rhythmk (5/13/2014)

---

With the help of Eirikur Eiriksson's code.You acn try this.

;WITH test

AS

(SELECT POLICY_DETAILS_ID,HISTORY_ID,CODE_ID,

ROW_NUMBER() OVER(PARTITION BY POLICY_DETAILS_ID,HISTORY_ID ORDER BY code_id) AS rn

FROM @POLHIST)

SELECT POLICY_DETAILS_ID,HISTORY_ID,

MAX(CASE WHEN rn = 1...

:-DNice MM

😎

Quick solution

😎

Use tempdb;

GO

DECLARE @CUST_PAY TABLE

(

CustNO INT NOT NULL

,InvNO INT NOT NULL

,ChkNO INT NOT NULL

);

INSERT INTO...

dndaughtery (5/12/2014)

---

I agree, I enabled as many tranformations as possible to run in parallel and removed a lot of merge joins, sorts and just did a join in the oledb...

A lot and some, seriously the more the merrier.

😎

Apart from straining the neck:hehe:, not really, most who I have...

Lynn Pettis (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

ChrisM@Work (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

Mike Saunders NL (5/12/2014)

---

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not mentioned. Is...