FORMAT 'G17' vs 'G'
sql-server-2019
Cade Roux
Cade Roux
11
`FORMAT` is implemented in CLR, but the overall question can be answered in T-SQL terms.
Paul White
I have to put the tempdb on the same disk with data and logs, how to mitigate risk?
2
sql-server
James Jenkins
James Jenkins
6
Probably the simplest way would be to turn off autogrowth for all tempdb files, making sure to set them to a reasonable fixed-size based on your workload and available space.
Josh Darnell
Why Does One Constraint Prevent A Sort?
sql-server
meme
meme
11
Essentially it's the same reason
Paul White
Why does adding a TOP allow the SQL Server query optimizer to find a plan that can honor a FORCESEEK hint?
4
sql-server
Joe Obbish
Joe Obbish
14
Although the query text contains an `APPLY`, the optimizer rewrites this to a regular join using the `ApplyHandler` rule early in the compilation process (during simplification). The optimizer prefers joins over applies because it has more transformations for joins[^1](For background on the difference between join and apply, see my article [Apply versus Nested Loops Join](https://www.sql.kiwi/2019/06/apply-versus-nested-loops-join.html)).
Paul White
9
To supplement Paul's answer, ironically, the optimizer is capable of producing apply plan for the original query, if `OUTER APPLY` is used instead of the `CROSS APPLY`
i-one
Missed optimisations for ScalarGbAggToTop with MAX(nullable_column)
4
sql-server
Martin Smith
Martin Smith
12
You're quite right about the reason for the separate `NULL` and `NOT NULL` branches.
Paul White
Handling Erroneous Data Entry in SQL
10
sql-server-2012
DS Chains
DS Chains
6
[`TRY_CONVERT`](https://docs.microsoft.com/en-us/sql/t-sql/functions/try-convert-transact-sql?view=sql-server-ver15) is what you are after:
Jack Douglas
Confused about STRING_SPLIT
8
sql-server-2019
Humble novice
Humble novice
11
`STRING_SPLIT` [is a table-valued function](https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver15):
Jack Douglas
Why is there an extra predicate with an IN clause?
1
sql-server-2019
Forrest
Forrest
10
The extra predicate on `#B` is added during query simplification by the "implied predicate" mechanism.
Martin Smith
DBCC CHECKDB WITH ESTIMATEONLY, significant over estimate.
sql-server-2014
James Jenkins
James Jenkins
Why doesn't disabling row goals give me a different query plan?
7
sql-server
Joe Obbish
Joe Obbish
15
In your first example, we can see the row goal and its effects on costing using undocumented trace flags 8607 and 8612 (as I describe in my article you linked to):
Paul White
