Thanks for the info.

Thanks all for your inputs.

Regards..Preethi

Thanks Kevin for your reply. I read numerous articles about MDW, its merits and demerits. The reason I was evaluating this less popular feature is because

1) It is NOT a...

Please give this a try- (I just revised the before query)

WITH cte_punches AS (

SELECT uidfirstname, uidlastname, reader, dtdate,

ROW_NUMBER() OVER (PARTITION BY uidfirstname, uidlastname ORDER BY dtdate, reader)

as punch_number...

I did setup on my machine and ran a query which uses the partition aligned index in both cases. But the IO Stats is similar. Could you please suggest supporting...

Thanks for your feedback.

Is the index stored on the partition scheme or not?

<Reply> Yes it is a partition aligned index.

if its, the partitioning column is effectively the first...

Thanks for replying. Any inputs on the index storage level \ tree traversal in fetching the data?

Also, check the unallocated space

by executing the statement

sp_SPACEUSED

Depending on this value, set the shrinkfile size

I don't think that is true. For test purposes, create a database with Initial size (.ndf file size) as 10 MB and try to shrink it to 1 MB using...

Did you try

DBCC SHRINKFILE (N'<logical file name of the .ndf file>' , <size in MB>) ?

<size in MB> - Specify the size you would like to shrink the file...

Do you also get this error?

Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "Excel Source" (1) failed validation and returned error code 0xC020801C.

If yes, you may need to run...