Viewing 4 posts - 1 through 4 (of 4 total)
I once read somewhere that when you're connected as the owner that permissions don't need to be checked when performing operations. Is this a significant performance gain?
October 15, 2018 at 12:42 pm
Thank you for the post Steve. What thoughts do you have about having a role own the schema?
October 15, 2018 at 10:41 am
A fun challenge! Here's a solution using a recursive cte:
DECLARE @FirstMonth DATE = GETDATE();
;WITH [cte] AS (
SELECT DATEFROMPARTS(DATEPART(YEAR,@FirstMonth), DATEPART(MONTH,@FirstMonth), 13) AS [d] -- the 13th for...
May 9, 2018 at 12:00 pm
Hey Steve, I didn't know you knew Jesus.
Praise be to our Lord and Savior!
God bless you brother! 😉
May 20, 2008 at 10:21 am
Viewing 4 posts - 1 through 4 (of 4 total)