RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

One of the more essential SQL Server tools is its trace utility. With it you can view the activity occurring against a SQL Server for diagnostic, informational, and other purposes. Because it lets you ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...

In the original proposal for the World Wide Web, Tim Berners-Lee wrote: A generic tool could perhaps be made to allow any database which uses a commercial DBMS to be displayed as a hypertext view. We ...

In recent releases of SQL Server, Microsoft has delivered a great deal of feature enhancements and performance improvements. This rapid delivery has been facilitated by some development changes at ...