All of this is absolutely terrible advice, and can only make a bad situation worse:

johnwalker10 (12/6/2016)

---

> Detach SQL Server database and move your MDF to save location.

> Create new...

Redesign the refresh to finish every night, no matter what.

Instead of blast-refreshing all of the rows, do it in smaller, fully-COMMITted batches, walking each source table in some key...

1. Index ID #7 is a non-clustered index. It contains copies of table data (the index keys),...

When you connected to your instance over the VPN with SSMS, did you ensure you are also using Named Pipes for communication, and not TCP/IP, so you're attempting the same...

That will not break the transaction log chain, because you still have every transaction log backup you've taken. The oldest of them reside in one location, the newest reside in...

Describe 'in two backup paths'.

Are you backing up to two locations at the same time using the MIRROR TO keyword of the BACKUP command? If that's what you mean, then...

Fun with recursion 🙂

CREATE TABLE #t (a tinyint NOT NULL, b VARCHAR(10), c VARCHAR(10))

GO

INSERT #t (a, b,c) VALUES (1, 'ab', 'cd')

INSERT #t (a, b,c) VALUES (1, 'ef', 'gh')

INSERT #t (a,...

Is there a TDE-encrypted database involved?

Each new row will go to the page in each index where it belongs, based on its new place in the index. If there happens to be enough room on...

MiguelSQL (7/8/2016)

However, two days later, the fragmentation levels are again at 37% and we are having the same issue.

What can I do to narrow down the issue?

The index is

CREATE NONCLUSTERED...

It could simply be a standard step in creating an exception to a security rule. Just document a few relevant specific tasks that require the level of sysadmin status to...

What is 'a problem'? Why did you have to restart? Was it to fix access to a cluster disk?

I looked at the image you posted.

Wait time = 0ms. It's a disk read. That's what they look like. PAGEIOLATCH_* waits occur during disk reads. With that as both your...

If this is an interview, then 'the needful' means "admit you don't know".