So what exactly is the expected output from the sample data you posted? And what exactly is the problem with the query you posted?

Helpseeker (2/12/2016)

---

Drew's query is perfectly fine. The issue was with my data. when i checked the data from source table, Machine ID and Instance Key were not primary key. hence...

manole_i (2/12/2016)

---

You are right, the index is not covered and it does a nested loop join with a key lookup.

With forceseek I got this:

Scan count 1, logical reads 6046852, physical...

Is there a question in here, or are you just sharing what you did?

If there is a question, then please post:

* CREATE TABLE statements for the table

* INSERT statements with...

Which part of "sorry, you can't" was unclear to you?

The Books Online topics on TDE are littered with warnings about backing up your certificate. For instance here:

"Data loss will result...

Sergiy (2/11/2016)

---

Never ever use NVARCHAR(MAX) for column...

Your cursor is dynamic. Which means that it is not only very slow, but also re-evaluated for every fetch.

After the first pass through the loop, a row exists in EMP...

Anyway, back to out regular scheduled content for this topic....

Terminator

Skylanders Giants?[/quote]

No, I had actually never heard of that. (Does that drop me a few points...

sqlfriends (2/10/2016)

---

So I think now I came to the two approaches by your posts:

1. create a noteTable for each parent Object. I heard this is proved preferred design.

The only...

Here you go:

https://msdn.microsoft.com/en-us/library/ms187928.aspx

If you are on SQL Server 2012 or better, look here as well: https://msdn.microsoft.com/en-us/library/hh974669.aspx

Sorry, you can't.

If there were a way to get to the data in that database without knowing the password, then any hacker who somehow gained access to the file would...

Do not expect this use of Apply to reduce the number of calculations the optimizer puts in the plan. It might, but it often does not.

However, those computations are incredibly...

Is the plan with the index seek *only* an index seek? Or is it a combination of an index seek, a nested loops, and a key lookup?

I assume the latter....

ThomasRushton (2/11/2016)

---

Ed Wagner (2/11/2016)

---

djj (2/11/2016)

---

Ed Wagner (2/10/2016)

---

Humid...