What is your business logic? Why would you select (X,Y,60) and not (Y,X,60)?

nhimabindhu (12/4/2014)

---

We should not use a staging table while loading from source we should pull unique records in single table and the duplicate in next table without using row_number,rank &...

vignesh.ms (12/3/2014)

---

Though I created a NCI, execution plan shows only CI scan.

1. What is the problem, why the optimizer goes with the index seek?

2. Do you need any...

Easiest option: dump records in a staging table. Then select again and use the ROW_NUMBER function to indicate duplicates. Everything with row number 1 goes into the unique table, all...

I had to Google this, because I did not understand at least 9 words from that question. 😀

Nice question, definately learned something.

eXtended Events

Nice question.

The original INSERT statement misses one quote though.

But I figured out this was a typo and it had no influence on the answer. 😎

Do you also understand the code? If it crashes on your production...

WITH cte AS

(

SELECT

SALESMAN_ID

,ORDER_NO

,ORDER_TOTAL

,rnk = RANK() OVER (PARTITION BY SALESMAN_ID ORDER BY ORDER_TOTAL DESC)

FROM dbo.SYSOENT

WHERE ORDER_DATE >= '1/1/14'

)

SELECT TOP 3 SALESMAN_ID,ORDER_NO,ORDER_TOTAL

FROM cte

WHERE rnk <= 3

ORDER BY ORDER_TOTAL DESC;

Eirikur Eiriksson (12/2/2014)

---

Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion

😎

DECLARE @STR VARCHAR(100)='My name is Shiva';

DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN FROM(SELECT ROW_NUMBER() OVER...

Use the excellent splitter function by Jeff Moden[/url] and use a space as the delimiter.

Sort the results in descending order and concatenate them back together[/url].

First thing that comes to mind is to compare the execution plans from both servers.

SQLAssAS (12/2/2014)

---

Thanks - just going through the set up of the catalog. It looks like this method uses CLR. Whats your view on that? Is this safe to use \...

SQLAssAS (12/2/2014)

---

We have some SSIS Packages which use a project level connection manager. Obviously if we schedule a single package from this project to run via a Job, it will...

Nice question, thanks.