May 2009 - Tip of the Week

Sort by: Most Recent | Most Viewed | Most Commented

  • Introduction to SQL Server Profiler

    How often do you find yourself with the need to know what statements are occurring on your SQL Server? Well, if you're like me the answer is "ALL THE TIME". Constantly Im asked about processes running on the server if things are slow. Even more importantly, I like to capture data from the system to use for trending purposes and to proactively diagnose performance problems before someone comes and tells me about it. Luckily, SQL Server comes with tools to capture such data, and to save...

  • When an outer join becomes an inner join

    Enclosed you will find how an improperly constructed OUTER JOIN query can turn into an INNER JOIN. An OUTER JOIN is described as a join where you want all data from one table along with any matching data from another table. In SQL Server the default behavior of using JOIN creates an INNER JOIN. But sometimes even if you use LEFT JOIN or LEFT OUTER JOIN, the query that you build may end up being an INNER JOIN. The first thing we will do is setup some test tables. Before you critique the tables, realize...
    Filed under: ,
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems