Holidays and Calendar Generation
Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.
2017-12-15 (first published: 2016-02-16)
7,640 reads
Paul Hunter
- Interests: Guitar, music
2016-02-15 (first published: 2016-01-29)
842 reads
BCP Format File Builder
Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.
2009-08-14 (first published: 2009-08-04)
2,369 reads
Blogs
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Question about deadlock
Hello DBAs, I am facing some deadlock issue and after investigation from trace flag...
Get Date Based on TimeOffSet and Day
Team I have a table which carries the below columns and values TimeOffSet >...
MSDTC and Always On AG
Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...
Ask SSC