SQL Server Assertion <simpletypes.cpp> stack dump when converting float to varchar with 128 style
sql-server-2014 sql-server-2012
Anonymous 2530 Anonymous 2530
14 >1. what’s wrong with convert style 128?
Paul White
7 This must be a bug with earlier versions of SQL Server. You can see it in action [with 2014 on db<>fiddle](https://dbfiddle.uk/um8qeyDl).
Jack Douglas
Strange behaviour with sample sizes for statistics updates
sql-server-2012
matthew mcgiffen matthew mcgiffen
7 Background
Paul White
How does SQL Server's optimizer estimate the number of rows in a joined table?
sql-server-2012
8kb 8kb
8 >*I think my understanding of the second estimate is incorrect and the differing numbers seems to indicate that. What am I missing?*
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
Get streak count and streak type from win-loss-tie data
sql-server-2012
jamauss jamauss
3 Another way to get the result is by a recursive CTE
Serpiton
0 One intuitive approach to solve this problem is:
Paul White
0 Since you are on SQL Server 2012 you can use a couple of the new windowing functions.
Mikael Eriksson
Empty blocking process in blocked process report
sql-server-2012
Tom V Tom V
2 I can't test this theory at the moment, but based on the [most recent capture data posted to GitHub](https://gist.github.com/anonymous/4c8df0a69cf5e2bd0a0741aed8b10019), I would say that the reason that thee `<process>` node is empty is that it requires a currently running request (many of the attributes are found in `sys.dm_exec_requests` and not in `sys.dm_exec_sessions`) and without a currently running request, it can't report any details, similar to how doing an `INNER JOIN` between `sys.dm_exec_requests` and `sys.dm_exec_sessions` will exclude rows where a Session is active but is idle due to no current request.
Solomon Rutzky
0 Blocked transactions can occur because of lock escalations.
John K N
SQL Server unpredictable select results (dbms error?)
sql-server-2012 sql-server-2008
Ryszard Bocian Ryszard Bocian
7 >*Are we doing something wrong or is it SQL Server error?*
Paul White
What is the purpose of this Uniq1002 column in this index scan?
sql-server-2012
Hannah Vernon Hannah Vernon
5 >Ostensibly, this represents the uniqifier used in the non-unique clustered index. Is that the case?
Paul White
3 In order for SQL Server to create a *non-unique* clustered index, a hidden "column" is added to the physical structure of the clustered index. That hidden column is known as the uniqifier, and as its name implies, provides a mechanism to ensure that every row in the clustered index is unique.
Hannah Vernon
Why 0 is equal to empty string?
sql-server-2012
gotqn gotqn
11 That is just documented behavior. I don't think anyone messed with the settings.
Tom V
Is there a better option than Union All for multiple selects from the same row?
sql-server-2012
JustinDoesWork JustinDoesWork
3 You can use `CROSS APPLY ... VALUES` to `UNPIVOT` multiple columns
Martin Smith
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.