Outer Join – What am I missing (SQL Spackle)
This article shows how to find missing rows in a table using a outer join.
2015-02-27 (first published: 2013-11-12)
21,458 reads
Patrick Cahill
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)
16,990 reads
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.
2011-06-13
7,805 reads
Blogs
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Daily Coping 18 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Storage Field Day 23 – SIOS
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Forums
sql server enterprise edition or standard
Hello, I was looking over the Edition specifications, and Standard is capped at 128...
Quick Question on 2019 to older version?
A client of ours is upgrading their database to SQL Server 2019. The edition...
Mapping network drive to SSMS
Hi, I need to perform backup and save it in network drive. I have...
Ask SSC