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)
8,218 reads
Paul Hunter
- Interests: Guitar, music
2016-02-15 (first published: 2016-01-29)
848 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,371 reads
Blogs
STRING_SPLIT Basics–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
Forums
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Identity Insert
hopefully a quick one This tsql SET IDENTITY_INSERT dbo.tblSCVMatchedv3 ON insert into dbo.tblSCVMatchedv3 select...
SET STATISTICS equivalent
Hello Is there an equivalent for monitoring things like IO, reads, writes, ... produced...
Ask SSC