We make production deployment at least once a week. So for each deployment I need to update my script to add or remove tables from articles ? And since it...

It will be much longer. Shrink with emptyfile pushes data page-by-page (or extent-by-extent) from one file to another, while rebuilding whole index is faster. Compare when you alter index with...

You can run differential backup. For these 4 days, it will be smaller than full.

You can't shrink file that has no empty space. Shrinking just releases empty space from files to OS.

If you want to get rid of a smaller file:

1. Script out all...

The primary goal of partitioning is to reduce maintenance efforts and time by limiting index rebuild jobs only to latest partitions and implementing partial backup (with setting prior partitions to...

Does this mean that if you select * from table where your_value = .... does not...

You can split only the last range, for example 2014-05-31, but not in the beginning or the middle, however please test it, I had such a case long time ago.

Sharing...

rangu (6/5/2014)

---

:), here it goes.

Below is the PF i was using earlier, if you see the oldest day available is 20081231. Now the requirement is to extend this for...

DM_CV_AGGR_FACT_POLICY_COVERAGE_ID] [int] IDENTITY(1,1) NOT NULL -- is ever increasing.

But place it on the 1 st place in your clustered index. It still can be partitioned by BIZ_MONTHYEAR even if...

My pleasure.

Welcome to ask more questions should they arise.

CREATE CLUSTERED INDEX [IX_AS_OF_TS] ON [CREDIT_RW].[HISTORICAL_Test]

(

[AS_OF_TS]

)

WITH (DROP_EXISTING = ON, ONLINE = ON, DATA_COMPRESSION = NONE)

ON [PRIMARY]

SELECT POWER (10,6) + FLOOR(RAND()*POWER(10,6.9))

SELECT FLOOR(RAND() * 10000000)

Recreate clustered index on PRIMARY or any other FG.

You can do it WITH DROP_EXISTING = ON

Page compression usually improves performance in most of the cases, however not in all of them. It compresses the pages so that more data can fit into a page. It...