Outer Join – What am I missing (SQL Spackle)
This article shows how to find missing rows in a table using a outer join.
2024-08-28 (first published: 2013-11-12)
21,572 reads
Patrick Cahill
Returning 0's in a SUM (SQL Spackle)
Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.
2024-08-28 (first published: 2011-06-13)
7,875 reads
Execute As
Learn how you can use Execute As in a stored procedure to control permissions. This article includes an example that limits access to encryption routines for users.
2013-10-11 (first published: 2011-02-02)
18,051 reads
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
Starting to Estimate Disk Storage for Memory-Optimized Tables
Comments posted to this topic are about the item Starting to Estimate Disk Storage...
Keep. It. Simple.
Comments posted to this topic are about the item Keep. It. Simple.
case statement with and like operators
Hello, I'm trying to remove results from this sql statement where the custid like...
Question of the Day
Starting to Estimate Disk Storage for Memory-Optimized Tables
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers