Joe Obbish
answers / questions / communities
answer date/timequestion typetitleanswer starsquestion date/time
2020-02-07 01:31QuestionUsing a Table as a Queue without sp_getapplock/sp_releaseapplock142020-02-03 17:20
2019-12-26 16:13QuestionWhy would a table with a Clustered Columnstore Index have many open rowgroups?32019-12-19 18:23
2019-09-05 01:45QuestionWhich costing factors go into the optimizer choosing different types of spools?42019-09-04 18:40
2018-05-15 23:38QuestionWhy does SQL Server use a better execution plan when I inline the variable?22018-05-15 21:45
2017-05-27 02:05QuestionWhy is it recommended to store BLOBs in separate SQL Server tables?32017-05-26 13:20
2017-04-21 15:33QuestionWhy does a subquery reduce the row estimate to 1?42017-04-21 15:33
2017-03-28 01:56QuestionWhat are different ways to replace ISNULL() in a WHERE clause that uses only literal values?22017-03-27 15:30
2017-02-20 14:39QuestionWhy does my SELECT DISTINCT TOP N query scan the entire table?72017-02-20 14:39
2017-02-21 05:50QuestionWhy does my SELECT DISTINCT TOP N query scan the entire table?62017-02-20 14:39