News for hackers. Stuff that matters.
Re:Hardly-used SQL Server functions that should be used more... by MarkusWinand on Thursday April 06, 2017 @12:45PM (#14052220)
I find their locking issues interesting: they are supporting snapshot isolation for quite some time now, but it's still not default and the community even hardly knows about it. Hint's like NOLOCK are more often suggested as "fix" as considering snapshot isolation.
Re:Hardly-used SQL Server functions that should be used more... by kbenson on Thursday April 06, 2017 @01:06PM (#14052435)
Unfortunately, my experience with SQL Server is almost entirely in interfacing with a third party applications SQL Server back-end. As such, I have zero control over the many queries that are run from the application clients and the schema in use. I just get to play in their sandbox. Unfortunately, like many sandboxes, it's also a litter box. :/