2025-03-03
487 reads
MMartin1
- Interests: Movies, Skating, S.Q.L. SERVER, Business Intelligence, Some Guitar.
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 […]
2021-05-19
11,873 reads
2016-11-01
1,302 reads
2016-01-13
1,497 reads
Blogs
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
AI Insights for Database Monitoring: A DBA’s Perspective
By Arun Sirpal
Second in a series on Ai and databases. One Story, three signals – I...
Crash-Consistent MongoDB Snapshot and Restore with Everpure Fusion
I’ve been working on a project that combines two things I spend a lot...
Forums
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Understanding SQL Server PARTITION BY with Examples
Comments posted to this topic are about the item Understanding SQL Server PARTITION BY...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers