Viewing 8 posts - 1 through 8 (of 8 total)
You can maybe tweak your code to create a new warehouse table and swap it with the existing one. The code below is from a Microsoft article on CTAS, specifically...
December 24, 2019 at 11:48 am
We currently use schemas to separate the different areas of our enterprise data warehouse (landing, staging and warehouse layers). We also have customer specific schemas for the landing and staging...
November 4, 2019 at 8:33 am
It's SSIS 2008 and I've set the Lookup for full cache, redirect rows to no match output. It does work but takes a long to time to cache as it...
December 16, 2011 at 1:56 am
A Lion Bar and a Coke on a Friday afternoon ends my week quite nicely!!
November 25, 2011 at 3:12 am
This might help
SELECT
[database_id]
,[object_id]
,[index_id]
,[partition_number]
, [csv column] = substring((SELECT ( ', ' + [alloc_unit_type_desc] )
FROM [sys].[dm_db_index_physical_stats] (8, NULL, NULL , NULL, 'SAMPLED') as s2
WHERE s2.[database_id] = s1.[database_id]...
October 28, 2011 at 4:02 am
Sorry, was a bit brain dead yesterday! That worked a treat thanks.
August 11, 2011 at 2:36 am
Viewing 8 posts - 1 through 8 (of 8 total)