TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?

Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.

Using Max()

How well do you know MAX?

RE: How to use SQL Profiler to filter NULL SQL login names? i.e NT authentication

Use - WHERE username IS NULL

RE: Is the title of this forum misspelled?

Yes Shew01 , You are right.goto http://www.sarbanes-oxley.com/

RE: Sending an SMTP email when row(s) change(s)

It would be simplest to send the mail from within the same procedure that updates the password, however, that means notifications wouldn't be sent if the table were updated directly.A trigger would solve that problem.  In this case it would be pretty simple, as a matter of fact I have done exactly this on one […]

RE: QOD 8/7/03

I think it is indicative of a poorly worded/minimally relevant question when only 12% of SQL Server professionals answer correctly. Unfortunately the choice that I would have selected if it had been available would be "Does this really matter?"