Alright so maybe that was a little misleading of a title… SQL Server join syntax changed awhile ago, when ANSI-92 joins became the norm. And Microsoft was threatening to remove it for awhile. The older outer join syntax just doesn’t work in SQL Server 2012.
We All Knew SQL Server Joins Were Changing…
I know… I’m not [...]
Archive | SQL Server DBA RSS feed for this section
SQL Server Join Syntax: It’s Changed!
Don’t Touch that Shrink Button!
This post is part 1 in a series on shrinking and transaction management. Part 2 is linked at the bottom or here. You can see them all in the Shrinking & Transactions category.
This topic has indeed been done to death. Yet I still often encounter unnecessary database autoshrinks, scheduled shrink jobs and at times a seeming [...]
Recent Comments