In a talkback comment to my review, "CSharper" pointed me at one solution to finding the LINQ equivalent of a SQL "SELECT DISTINCT" query: tack on a LINQ .Distinct () method call to the query ...

Notifications You must be signed in to change notification settings My SQL Story: Discovering Unique Ages Over 30 During a data project with a big employee dataset, I needed to find out how many ...

Sql query help, selecting newest distinct record Hoostine May 12, 2008 Jump to latest Follow Reply ...

Now, this will still not be particularly quick if you don't have any decent indexes. Have SQL Management Studio generate the execution plan for this query and see what's taking the most time.

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.