Search results for query: *

Yes that's correct, so now I am selecting records from live table and inserting into my staging table...so let say If i receive 2 months of data in my daily feed I will load staging table first and then select 2 months of data from live table and insert them into staging table --> then because...

Existing table structure is in production and there are number of reports running..in my case performance is much better because all the reports use acquisition date because current table is partitioned by month using acquisition date I can't change the existing structure...How about if i use...

I would like shed more lights on this, My table is partitioned by month using acquisition date and I receive data feed which can have 3 to 4 months of data. How do I use ALTER SWITCH to load this data into actual partition table?

I have table which is partitioned by acquisition date Table Structure (TableName : Inventory) Vendor_Name [varchar](80) NULL, Model_Name [varchar](80) NULL, AcquisitionDate [datetime] NOT NULL, Qty [bigint] NOT NULL Partition Function For Inventory Table : CREATE PARTITION FUNCTION...