MMartin1

  • Interests: Movies, Skating, S.Q.L. SERVER, Business Intelligence, Some Guitar.

SQLServerCentral Article

Hidden Pitfalls with INNER JOIN and NOT IN Operators

I want to show you how two common operators can deceive you into believing you have constructed a proper SQL statement for your solution. We may want to filter results in a table by using using a IN/NOT IN or a INNER JOIN/LEFT JOIN to another table. There are a couple of hidden dangers here […]

3.77 (13)

You rated this post out of 5. Change rating

2021-05-19

11,356 reads

Blogs

A New Word: Immerensis

By

immerensis – n.  the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By

In this post, I will guide you on how to deploy a dockerized simple...

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

Read the latest Blogs

Forums

mysql query timeout upped but job still fails about same number of minutes in

By stan

hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...

Somebody realized to configure Cluster-Aware updating on VMWare nodes

By boskabouter 007

Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...

is it cache or something else

By stan

hi a few days ago i narrowed down the cause of a new problem...

Visit the forum

Question of the Day

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

See possible answers