External verification of `SIGNBYCERT()` signatures from SQL Server 2016
3
sql-server-2016
NReilingh
NReilingh
How do I write "proper" cursors?
1
sql-server
Hannah
Hannah
9
`CURSOR_STATUS` provides a nice way of ensuring the cursor is ready and contains rows.
Hannah
Breaking infinite loop in recursive CTE
25
sql-server
artaxerxe
artaxerxe
8
Jack's solution is good for scenarios where loops can only be encountered at the beginning of traversing the hierarchies.
Andriy M
4
With a slightly simplified case:
Jack Douglas
Replacing A Scalar UDF That Processes Variable Numbers Of Rows
46
sql-server-2016
meme
meme
11
This is a fairly literal, but general, interpretation of the underlying recursive algorithm implemented as an inline table-valued function:
Paul White
Discarded alternatives
sql-server
i-one
i-one
Check constraint and index scan
1
sql-server-2019
sabin
sabin
8
Explanation
Paul White
Database using Filestream in Recovering state
18
sql-server
John K N
John K N
10
It looks that FILESTREAM initialization happens when RsFx driver is not well initialized yet. The RsFx is file system minifilter driver, it is used by the SQL Server to expose FILESTREAM content via UNC-share.
i-one
Missed opportunity for a seek where everything is NULL
17
sql-server
Mikael Eriksson
Mikael Eriksson
11
This is an issue I see quite often when the 'new' cardinality estimator is used.
Paul White
Query Store Issue or Totally Unrelated
7
sql-server-2016
John K N
John K N
5
Since the Query Store change you made succeeded, I think this lock timeout error is unrelated.
Josh Darnell
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
