Very good question, Steve.

I learned this the hard way a looooong time ago while preparing some migration scripts.

+1

Very easy one for anybody that has used this operator before, IMO.

Thanks, Steve!

Arrrrrgggghh.... Had it but then I changed my mind.

Thanks, Steve.

Thanks for the question.

I'm on a roll lately! 😀

But I must say that I do not use this feature in my coding.

Good question, Steve. Thanks.

+1000

Thanks for the question, Steve.

Even though there is clearly an error in the listing of possible results, the requirements clearly point to the use of the Dense_Rank funciton, IMO.

... I...

Todd Reddinger (9/30/2014)

---

the ORDER BY in the OVER clause orders the records returned by the select. By adding an order by on the select, a differect set of records is...

andrew.ing (9/30/2014)

---

The mistake in the question was overlooking the fact that sys.syscolumns will have different contents in different databases.

But more than that, you couldn't guarantee the statement would return the...

I got it right but it's true that you can't really know how many different distinct values you will generate unless you know for certain the values that the Rank...

I got it right.

I figured enabling a feature wouldn't really save up disk space (not installing it would) and probably wouldn't speed up the installation process (or at least not...

Thanks for the question, Steve.

I think this is a fairly easy question. The only thing that got me thinking was whether or not it would throw an error.

A truck

Interesting question, thanks!

LOL at this! 😀