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)

2021-05-19

9,312 reads

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Is TemporalTable SysStartTime available before performing an insert/Update?

By Dwaine Wright

I want to align a Date column (datetime2(7)) with the same full resolution date...

multiple PAGELATCH_UP waits on data file

By bobrooney.81

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...

dynamic update to SP

By Bruin

Looking for suggestions\examples of how to update a SP that the table used changes...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers