2 ms·
I've worked with SQL Server for 20 years now, and you'd be amazed at how often the issues listed here actually come up. My Damascus moment was using Postgres f
by moomin 13y ago
I've worked with SQL Server for 20 years now, and you'd be amazed at how often the issues listed here actually come up. My Damascus moment was using Postgres for the first time. I kept discovering that it "just did the right thing" in a way that SQL Server never seems to.
- VladRussian2 13y agoSQL server by default creates tablespaces with non ANSI SQL NULL behaviour. Exlicitly specifying ANSI SQL compatibility when creating tablespace makes it "to do the right thing" Edit: was doing it many years ago so forgot the details (or they changed :), so just checked - it is "alter database" that can switch various "ansi_null" default settings into ON from default OFF
- chiph 13y agoThe default in upcoming versions of SQL Server will use the ANSI NULL behavior. http://msdn.microsoft.com/en-us/library/ms188048.aspx http://msdn.microsoft.com/en-us/library/ms188048.aspx