Join SQL Server tables where columns include NULL values
Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.
2021-09-01
table
Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.
2024-01-16 (first published: 2021-06-04)
2,604 reads
Date Tables are Great for Users, but Not So Great for Performance
If you haven’t used a date table before, here are a couple of primers on how to create one and use it.
2020-08-27
2019-07-09 (first published: 2019-05-01)
905 reads
Blogs
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Secure Your SQL Estate: Best Practices for Azure SQL Security
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Forums
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Concerns over AI Chat Privacy
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1
Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale:...
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers