Timeline for How can I help SQL Server recognize my indexed view column is NOT NULL-able?
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| S Nov 7, 2014 at 10:03 | history | suggested | crokusek | CC BY-SA 3.0 |
Clarify the question headline to "indexed" view to match his example. (Non-indexed view would have a solution.)
|
| Nov 7, 2014 at 2:32 | comment | added | crokusek | This also appears to be an issue in a recursive cte when recursing on a non-nullable field (no aggregate) although an IsNull(..., 0) at the end can cure. | |
| Nov 7, 2014 at 2:24 | review | Suggested edits | |||
| S Nov 7, 2014 at 10:03 | |||||
| Oct 16, 2012 at 5:39 | comment | added | Marcel | Yes there are concerns, for example your ORM will create nullable types, which in turn will need extra care in code when using them, which is useless (or even misleading) in your case. | |
| Sep 12, 2011 at 5:04 | vote | accept | Nick Chammas | ||
| Sep 10, 2011 at 6:49 | history | tweeted | twitter.com/#!/StackDBAs/status/112417284106100736 | ||
| Sep 9, 2011 at 23:43 | answer | added | Jack Douglas | timeline score: 10 | |
| Sep 9, 2011 at 23:31 | answer | added | Aaron Bertrand | timeline score: 5 | |
| Sep 9, 2011 at 22:40 | history | edited | Nick Chammas | CC BY-SA 3.0 |
added link to code on gist
|
| Sep 9, 2011 at 21:44 | history | asked | Nick Chammas | CC BY-SA 3.0 |