Viewing 7 posts - 1 through 7 (of 7 total)
Thanks for the response. Here is the nice blog why there would be blockings.
But there are other precautions that we could take to reduce the blocking.
June 2, 2016 at 3:03 am
yes there is an update trigger on this table and there is enough space so, I don't think that is causing the issue.
June 1, 2016 at 10:46 am
We are trying to create index on a huge table, we expect it to run for around 1hr (as we tried in a replica copy with same data), but we...
June 1, 2016 at 5:22 am
Thanks for the reply, but In this code we are not specifying any file path, where does the .dat file falling into. any default location or do we need to...
February 24, 2016 at 8:49 am
yes, you were right, they are set options while creating/altering each Indices, I could see few are persisted and others are not (EX: ONLINE, SORT_IN_TEMPDB, STATISTICS_INCREMENTAL, MAXDOP). They are just...
February 8, 2016 at 5:48 am
These are the index options
IGNORE_DUP_KEY
STATISTICS_NORECOMPUTE
DROP_EXISTING
ONLINE
DATA_COMPRESSION
February 8, 2016 at 5:19 am
Viewing 7 posts - 1 through 7 (of 7 total)