TechQA.

Question

SQL slow outer apply trying to read from 2 sharded tables

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

0

Answer

41

Views

SQL slow outer apply trying to read from 2 sharded tables

41 views Asked by Brian Heward At 20 February 2024 at 19:30

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

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

62 views Asked by TripleCute At 17 November 2023 at 18:03

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

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

87 views Asked by Sean Werkema At 16 June 2023 at 15:34

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

Convert costly OUTER APPLY to LEFT JOIN

98 views Asked by codingIsCool At 02 June 2023 at 14:49

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

DISTINCT results of CTE Outer Apply return empty set

65 views Asked by Joseph Shirk At 04 May 2023 at 18:48

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

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?

71 views Asked by Sunil Jadhav At 14 November 2022 at 07:23

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

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

70 views Asked by Jason Daniel At 04 November 2022 at 10:22

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

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

37 views Asked by Pauli du Plooy At 07 October 2022 at 10:34

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

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

128 views Asked by aquawhale At 15 July 2022 at 09:46

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

Replace OUTER APPLY

742 views Asked by Cătălin Rădoi At 11 July 2022 at 09:00

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

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

561 views Asked by Qëndrim Izairi At 05 March 2022 at 01:44

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

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

292 views Asked by Elie Antoun At 27 December 2021 at 11:43

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

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

690 views Asked by TProgram At 06 December 2021 at 10:19

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

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

212 views Asked by Leonardo Daga At 23 October 2021 at 08:53

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

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

42 views Asked by learning coding At 24 June 2021 at 19:38

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

Filldown with outerapply

150 views Asked by smpa01 At 24 June 2021 at 15:23

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

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

151 views Asked by Daniel At 26 May 2021 at 20:52

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

ORacle outer apply combination with group by

148 views Asked by atufi At 18 April 2021 at 13:27

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

SPROC with Outer-Apply returns too many rows

100 views Asked by KVN At 09 March 2021 at 22:00

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

OUTER APPLY in BigQuery

4.3k views Asked by Erechtheus At 17 February 2021 at 14:52

TechQA.

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

Popular Questions

Popular Tags

Trending Questions