Viewing 15 posts - 796 through 810 (of 49,571 total)
September 7, 2017 at 7:19 am
In that case, you need a scheduled job running on a regular interval. Use Windows Scheduler since you don't have SQL Agent.
September 5, 2017 at 1:37 am
September 4, 2017 at 3:12 pm
You want the status set to 2 when what exactly happens?
September 4, 2017 at 4:10 am
Since there are no filters other than the join, the most efficient way to execute that is probably with two full table scans. Do you really have no further restrictions...
September 4, 2017 at 1:35 am
rajeshn29.dba - Monday, September 4, 2017 1:10 AM
.fail over cluster & windows cluster difference
Do you mean a SQL cluster vs a...
September 4, 2017 at 1:16 am
September 2, 2017 at 12:55 am
September 1, 2017 at 1:52 pm
And if you try the
CONTINUE_AFTER_ERROR option on the restore?
Is the source DB intact?
August 31, 2017 at 11:20 pm
Threshold for triggering auto update != sampling rate.
The threshold is 20%. Jeff's talking about the sample rate.
August 31, 2017 at 1:19 pm
August 31, 2017 at 7:39 am
August 31, 2017 at 4:30 am
In this case it's an orphaned text blob.
The off-row data node is not referenced
As such, the row that the text blob belongs to is gone somehow and...
August 31, 2017 at 3:56 am
Look at the slow query. Is there a large difference between estimated and actual row count at the leaf level
Update the stats. Is the query plan better (better estimates)...
August 31, 2017 at 2:15 am
Viewing 15 posts - 796 through 810 (of 49,571 total)