2016-07-04 (first published: 2016-06-08)
852 reads
Generate row constructors for existing data
Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard
2013-11-14 (first published: 2013-10-31)
1,165 reads
Blogs
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys...
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Forums
Group by issue
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Ownership chaining
Hi, I have four views on one database to which one sql authenticated user...
Schedule Jobs on a Clustered SQL Server
Comments posted to this topic are about the item Schedule Jobs on a Clustered...
Ask SSC