This is a User Defined Function that returns a 1 if date is a holiday else, it returns a 0.The holidays are:New years Day, MLK Day, Presidents Day, Memorial Day, Independance Day, Labor Day, Columbus Day, Veterans Day, Christmas Eve and Christmas Day
2005-06-13 (first published: 2005-05-27)
287 reads
This is a replacement script for the first IsDateAHoliday. The first one was too slow and inefficient. This one is much better. Enjoy.IsDateAHoliday is a User Defined Function that accepts a date and returns a 1 if date is a national holiday and returns a 0 otherwise.The holidays are:New years Day, MLK Day, Presidents Day, […]
2005-06-03
410 reads
By Steve Jones
Rodney Kidd took some great shots of the keynote and published an album here:...
By Brian Kelley
here is the compiled video of the Red Teaming course Microsoft put together.
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
Hi all, Has anyone encountered an issue whereby using a distributed availability group...
hi, i have seen in my server sometimes some SPIDs get stuck. so we...
Recently I was asked to investigate the update statistics process on a particular database....
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers