Viewing 15 posts - 196 through 210 (of 274 total)
It ran successfully today. Thanks everyone
September 9, 2015 at 10:21 am
Thanks for the reply sir..I am not able to get why it failed. Could you please advise
September 8, 2015 at 8:08 am
I also got same error today:
Reorganize Index Description: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute...
September 8, 2015 at 1:37 am
Good morning Everyone,
I also got the same error today. Checked maintenance plan history, logs, event viewer etc but could not find anything. Could you please help
September 8, 2015 at 1:32 am
Dear Jeff sir,
Thanks a million for the wonderful explanation
September 7, 2015 at 8:55 am
Good morning Gail Madam and everyone,
Actually each SPID is blocking itself, and there are number of SPIDs like that.
September 7, 2015 at 7:07 am
Dear Jeff sir,
Thanks for contributing and helping beginner level people like me. Should the scans be lesser than seeks?
Actually, I did not understand the below statement:
" If the problem still...
September 7, 2015 at 5:12 am
Dear Jeff sir,
I have attached information of the index whose fragmentation increased to 95% the next day, after rebuilding with fillfactor=90. Shall i try rebuilding with fillfactor=80.
September 5, 2015 at 2:29 am
Dear Jeff sir,
Could you please let me know how to check how often an index is inserted
September 5, 2015 at 1:47 am
Could you please share the query to check last time when an index was rebuilt
September 5, 2015 at 1:31 am
Thanks for the suggestion sir
September 4, 2015 at 4:21 am
Dear Jeff,
In that case, how to find unused indexes.
September 1, 2015 at 11:40 pm
Good morning Gila Shaw Madam,
Actually, when the app team reports slowness in fetching data from application, we see Blocking due to access_methods_scan_range_generator and Latch_Ex. This may be co-incidence or may...
September 1, 2015 at 11:38 pm
Good morning Gail Shaw Madam and Everyone,
To confirm that an index is unused, should the values for seeks,scans,lookups and updates be zero. That is, only if
seeks=0 and scans=0 and...
September 1, 2015 at 12:32 am
Dear Jeff,
Both are non-clustered indexes. I will try setting fill factor=80 or 70. Thanks sir
August 30, 2015 at 11:43 pm
Viewing 15 posts - 196 through 210 (of 274 total)