Executions count reported by sp_QuickieStore 7

sql-server-2016

Anonymous 2148Anonymous 2148

9Hi there!

meme

sql server query error4

sql-server

Anonymous 2135Anonymous 2135

5This condition that compares `shour` with `datetime` is the problem:

ypercubeᵀᴹ

External verification of `SIGNBYCERT()` signatures from SQL Server 20163

sql-server-2016

NReilinghNReilingh

How do I write "proper" cursors?2

sql-server

Hannah VernonHannah Vernon

9`CURSOR_STATUS` provides a nice way of ensuring the cursor is ready and contains rows.

Hannah Vernon

Breaking infinite loop in recursive CTE25

sql-server

artaxerxeartaxerxe

8Jack's solution is good for scenarios where loops can only be encountered at the beginning of traversing the hierarchies.

Andriy M

4With a slightly simplified case:

Jack Douglas

Replacing A Scalar UDF That Processes Variable Numbers Of Rows46

sql-server-2016

memememe

11This 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-onei-one

Check constraint and index scan1

sql-server-2019

sabinsabin

8Explanation

Paul White

Database using Filestream in Recovering state18

sql-server

John K NJohn K N

10It 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 NULL17

sql-server

Mikael ErikssonMikael Eriksson

11This is an issue I see quite often when the 'new' cardinality estimator is used.

Paul White