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-10-25 (first published: 2011-06-13)
10,068 reads
This article shows how to find missing rows in a table using a outer join.
2024-10-18 (first published: 2013-11-12)
24,165 reads
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,148 reads
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
I received the following notification a few hours ago. It seems legit but has...
Hi, Need your help. I've a SP that is using Update statement on a...
I have query which is filling TEMPDB I need suggestion how to modify this...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers