Martin Smith
answers / questions / communities
answer date/timequestion typetitleanswer starsquestion date/time
2020-05-15 05:54QuestionGROUPING SETS returning unexpected results with calculated expression92020-05-14 18:01
2020-05-08 10:11QuestionWhy is there an extra predicate with an IN clause?92020-05-07 21:47
2020-05-04 10:44QuestionHow can I enforce that values in a table column match the Regular Expression “[axyto0-9\s]{0,2}[\s0-9]{0,10}”?122020-05-04 10:44
2020-04-27 11:45QuestionSQL Server 2019 executes unreachable code102020-04-27 10:28
2020-01-13 20:17QuestionIncorrect Result with Apply102020-01-13 16:44
2019-11-18 17:33QuestionHow to get the parameter values of a stored procedure that's in the middle of execution?32019-11-18 15:59
2019-05-02 16:07QuestionWhy does this derived table improve performance?42019-05-02 14:13
2019-04-26 15:08QuestionCan SQL Server create collisions in system generated constraint names?42019-04-26 10:08
2018-12-18 15:59QuestionWhy is this stream aggregate necessary?72018-12-18 15:42
2017-02-19 20:15QuestionWhy does this seek on BIGINT col have extra constant scan, compute scalar, and nested loops operators?42017-02-18 22:11
2016-07-07 10:24QuestionIs it legal for SQL Server to fill PERSISTED columns with data that does not match the definition?32016-06-30 13:34
2016-01-06 20:20QuestionWhat does the position of the ON clause actually mean?52016-01-06 20:14
2013-12-25 21:42QuestionIs it possible to view LRU-K values in SQL Server?52013-12-03 20:09
2013-10-04 23:26QuestionWhy does @@dbts increase after backup/restore?52013-10-04 13:32
2013-03-13 10:46QuestionHow do I insert one or multiple default rows?42013-03-13 10:09
2013-02-27 21:38QuestionIs there a better option than Union All for multiple selects from the same row?32013-02-27 21:29
2013-02-14 11:46QuestionWhy are non-digits LIKE [0-9]?42013-02-14 11:37
2013-02-04 10:39QuestionCast to date is sargable but is it a good idea?52013-02-04 07:58
2012-04-11 22:22QuestionWhat's the difference between a temp table and table variable in SQL Server?52012-04-11 22:22
2012-03-12 11:49QuestionCan you explain this execution plan?82012-03-12 02:29
2012-02-19 16:26QuestionWhy is using a table variable more than twice as fast as a #temp table in this specific case?72012-02-18 21:30
2012-02-13 09:29QuestionWhat's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?32012-02-13 08:10
2011-12-01 10:53QuestionShared Lock issued on IsolationLevel.ReadUncommitted32011-12-01 02:25
2012-07-08 11:43QuestionDoes SQL Server read all of a COALESCE function even if the first argument is not NULL?42011-09-19 15:06
2013-09-24 21:05QuestionDoes SQL Server read all of a COALESCE function even if the first argument is not NULL?52011-09-19 15:06