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".

Also, once you TDE any database on an instance, then tempdb also automatically becomes a TDE database to prevent any TDE-encrypted data from being written unencrypted to a tempdb file....

We use TDE with an HSM for several multi-TB highly-transactional databases.

Once you set up and enable the encryption, it will run silently in the background encrypting the database while normal...

The foundation certification for both SQL Server dev and DBA is MCSA:

https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx

Once you have passed the three MCSA exams, you may work toward one of the SQL Server MCSE certifications.

-Eddie

Why BCP at all? You're adding the expensive steps of converting all of your data into and back out of text while forcing all of it to be written, flushed,...

Queries aren't routed, the entire connection is. The connection does not change based on the type of query executing on that connection. You will connect to the Listener in either...

If you have a support agreement, call them up and scream at them.

What does 'inaccessible' mean?

After the failover, is the database online and available on the second instance?

If the database isn't online, then there's one troubleshooting path.

Have those domain users...

Most efficient would be the 3-byte date data type.

Second would be an integer storing the number of days since January 1, 1900 (use DATEDIFF(d, 0, <input_date_value>) to calculate the value,...