To get the data for the most recent row, use row_number:

LEFT JOIN (SELECT UserID, AdressID,

...

The upper levels of the indexs are not scanned, nor are they always full. No, you should not be worried about fragmentation in these levels as long as leaf level...

There is a problem with that solution: it relies on undefined behaviour. That is, there are no guarantees that SELECT @sql = @sql + col with produce what you expect....

Blimey? Must be some lingo local to Port Moresby.

Any way, since I don't think that there was a post with CROSS JOIN for unpivotting, here is an example, taken...

Glenstr (9/11/2013)

---

So, are you saying that if I create the certificate (something I know nothing about) on the AuditDb database and assign a user to it, then all users will...

Ah, I see. I had just completed an unpivot solution (using CROSS JOIN) in another thread prior to reading this thread. I need to look into this idea more.

I'm sorry, but I need to be quick; I'm already past my bedtime.

You need a table of numbers - or in this case a table of dates to fill up...

Seems like your manager needs a promotion to a position where he can't make any damage. :--)

The reason that it does not work is that the plain user does not have access to that other database. You could achieve this by enabling the guest user, but...

While you are at it, you may also be interested in beta_lockinfo. Or may be you are not. But since I wrote it, I had to plug it. :--) The...

Somewhat odd to use CROSS APPLY here. The normal is CROSS JOIN. Of course since there is no correlation on the right side, the CROSS APPLU...

Here is the pattern for a unpivot operation:

SELECT s.Name, CASE n.n WHEN 1 THEN s.Mark1

...

Beside checking SQL Server Agent for jobs, also check Task Manager in Windows.

SQLSteve (9/11/2013)

---

I was always under the imrpession that auto grow should be set to a fixed amount? Or isn't it as much of an issue being a % for the...

Grant Fritchey (9/11/2013)

---

Step into the light. Extended Events are better in every possible way. Except they don't work with distributed replay. Oh, and they can't be directly integrated with Performance...