Question

SQL slow outer apply trying to read from 2 sharded tables

score 41 · Answer 1 · 2024-02-20T19:30:20.663000

41

Views

SQL slow outer apply trying to read from 2 sharded tables

Published on 20 February 2024 at 19:30

score 62 · Answer 2 · 2023-11-17T18:03:17.290000

62

Views

Using Outer Apply to Compare 2 columns of one table that match values with 1 column in a different table

Published on 17 November 2023 at 18:03

score 87 · Answer 3 · 2023-06-16T15:34:11.623000

87

Views

How can I union values across multiple columns of a result set without repeated table scans in the query plan?

Published on 16 June 2023 at 15:34

score 98 · Answer 4 · 2023-06-02T14:49:33.563000

98

Views

Convert costly OUTER APPLY to LEFT JOIN

Published on 02 June 2023 at 14:49

score 65 · Answer 5 · 2023-05-04T18:48:55.510000

65

Views

DISTINCT results of CTE Outer Apply return empty set

Published on 04 May 2023 at 18:48

score 71 · Answer 6 · 2022-11-14T07:23:31.127000

71

Views

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if 'yes' then how?

Published on 14 November 2022 at 07:23

score 70 · Answer 7 · 2022-11-04T10:22:37.807000

70

Views

SQL: How to resolve varchar numeric conversion using OUTER APPLY and SELECT TOP (1)?

Published on 04 November 2022 at 10:22

score 37 · Answer 8 · 2022-10-07T10:34:43.850000

37

Views

Is it possible to do a outer apply on two tables from different database engines to get unmatched records?

Published on 07 October 2022 at 10:34

score 128 · Answer 9 · 2022-07-15T09:46:12.333000

128

Views

Oracle Create Materialized View With Outer Apply Throws "missing right parenthesis" Error

Published on 15 July 2022 at 09:46

score 742 · Answer 10 · 2022-07-11T09:00:48.737000

742

Views

Replace OUTER APPLY

Published on 11 July 2022 at 09:00

score 561 · Answer 11 · 2022-03-05T01:44:38.967000

561

Views

Im trying to use DISTINCT and ORDER BY DESC with OUTER APPLY (2 tables), cannot get DESC order

Published on 05 March 2022 at 01:44

score 292 · Answer 12 · 2021-12-27T11:43:23.710000

292

Views

I have a syntax error in my Outer Apply statement, I can't understand why

Published on 27 December 2021 at 11:43

score 690 · Answer 13 · 2021-12-06T10:19:39.287000

690

Views

distinct result by entire table when using cross apply on json and order by with case

Published on 06 December 2021 at 10:19

score 212 · Answer 14 · 2021-10-23T08:53:31.840000

212

Views

Using .NET Core nested LINQ instruction in migration from SQL Server to MySQL

Published on 23 October 2021 at 08:53

score 42 · Answer 15 · 2021-06-24T19:38:20.117000

42

Views

Get the latest entry time using SQL if your result returns two different time, should I use cross or outer apply?

Published on 24 June 2021 at 19:38

score 150 · Answer 16 · 2021-06-24T15:23:21.943000

150

Views

Filldown with outerapply

Published on 24 June 2021 at 15:23

score 151 · Answer 17 · 2021-05-26T20:52:09.830000

151

Views

Failed to initialize sqlcmd library with error number -2147467259. - XML Column

Published on 26 May 2021 at 20:52

score 148 · Answer 18 · 2021-04-18T13:27:44.220000

148

Views

ORacle outer apply combination with group by

Published on 18 April 2021 at 13:27

score 100 · Answer 19 · 2021-03-09T22:00:42.440000

100

Views

SPROC with Outer-Apply returns too many rows

Published on 09 March 2021 at 22:00

score 4.3k · Answer 20 · 2021-02-17T14:52:53.463000

4.3k

Views

OUTER APPLY in BigQuery

Published on 17 February 2021 at 14:52

List Question

SQL slow outer apply trying to read from 2 sharded tables

Using Outer Apply to Compare 2 columns of one table that match values with 1 column in a different table

How can I union values across multiple columns of a result set without repeated table scans in the query plan?

Convert costly OUTER APPLY to LEFT JOIN

DISTINCT results of CTE Outer Apply return empty set

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if 'yes' then how?

SQL: How to resolve varchar numeric conversion using OUTER APPLY and SELECT TOP (1)?

Is it possible to do a outer apply on two tables from different database engines to get unmatched records?

Oracle Create Materialized View With Outer Apply Throws "missing right parenthesis" Error

Replace OUTER APPLY

Im trying to use DISTINCT and ORDER BY DESC with OUTER APPLY (2 tables), cannot get DESC order

I have a syntax error in my Outer Apply statement, I can't understand why

distinct result by entire table when using cross apply on json and order by with case

Using .NET Core nested LINQ instruction in migration from SQL Server to MySQL

Get the latest entry time using SQL if your result returns two different time, should I use cross or outer apply?

Filldown with outerapply

Failed to initialize sqlcmd library with error number -2147467259. - XML Column

ORacle outer apply combination with group by

SPROC with Outer-Apply returns too many rows

OUTER APPLY in BigQuery

Trending Questions

Popular # Hahtags

Popular Questions