Robert Miles robertmiles3

C#, Swift, ASP.NET, Xamarin

robertmiles3 / RecompileAndVerify.sql

Created June 28, 2017 20:10

SQL Server Recompile and Verify

	-- A comma-separated list of fully-qualified table names that should be marked for recompile
	DECLARE @ObjectRecompileList VARCHAR(MAX) = 'dbo.Table1,dbo.Table2,dbo.Proc1';

	DECLARE @ObjectsToRecompile TABLE
	(
	ObjectId INT,
	ObjectSchema VARCHAR(1000),
	ObjectName VARCHAR(1000)
	)
	DECLARE @ObjectsToVerify TABLE

robertmiles3 / GetNextDayOfWeek.cs

Created November 18, 2016 20:41

A DateTime extension method to get the next DateTime of a specified day of week (ie. "get next Tuesday")

	public static class DateTimeExtensions
	{
	public static DateTime GetNextDayOfWeek(this DateTime date, DayOfWeek targetDayOfWeek) => date.AddDays(targetDayOfWeek - date.DayOfWeek + (date.DayOfWeek < targetDayOfWeek ? 0 : 7));
	}