Steve Ford questions

Steve Ford answers

• Force Entity Framework 6 (EF6) to use nvarchar(MAX)
• SQL - How to find a value in a tree level data structure
• SQL Server - why is scanning done twice for the same table?
• SSIS Read file modification date
• Why does a FLOAT give me a more accurate result than a DECIMAL?
• slow query performance issue with partition and max
• Linq to Sql Count Include joins
• Substring after a space
• Why would SQL Server's SET DEADLOCK_PRIORITY HIGH not be honored?
• The value is returned instead of NULL when using function with OUTER APPLY