Viewing 15 posts - 1 through 15 (of 29 total)
George Vobr - Tuesday, January 1, 2019 5:50 AMToday's Qotd leads to a secondary question, "What's new in SQL Server 2019?".
I'm most...
January 2, 2019 at 8:03 am
Btw this returns 11 (or rather, '11'):DECLARE @s-2 VARCHAR(10)...
December 19, 2018 at 9:47 am
I had an Issue recently but nothing I found via Google had a...
December 19, 2018 at 9:40 am
It's also one of the first settings I change whenever someone asks me to tune up their database. The default setting of 0 isn't great for most server instances. In...
December 11, 2018 at 12:41 pm
I was about to complain that the question should have specified which version of SQL Server. Otherwise the correct answer is either '2" or "an error".
But I looked...
December 4, 2018 at 8:29 am
October 19, 2018 at 10:25 am
Is anyone else more disturbed by the query allowing for the possibility of a divide by zero error than by the correct way to cast to a decimal?
October 19, 2018 at 9:54 am
Comparing inserted and deleted tables is further made confusing by the requirement to "pair...
August 14, 2018 at 7:58 am
August 10, 2018 at 7:52 am
Keep in mind that this trick relies on behavior that is not only undocumented but officially undefined. There is no guarantee that this trick will work with the next SQL...
July 23, 2018 at 10:20 am
July 12, 2018 at 12:39 pm
July 12, 2018 at 9:33 am
July 12, 2018 at 9:25 am
Viewing 15 posts - 1 through 15 (of 29 total)